Rashmi has attended:
Excel Intermediate course
Excel Advanced course
Graph data copies from a PDF
Is there a way to copy a PDF graph into Excel?
RE: Graph data copies from a PDF
Dear Rashmi
Thank you for your question to our forum.
It is a question about how the PDF was created. If the graph is added to the PDF file as a picture you can right click the graph and save it as a picture. If the PDF file is created as a photocopy you cannot do this.
If it is created as a photocopy you can use ScreenShot tool in the insert ribbon to create a picture.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
RE: Graph data copies from a PDF
Thank you for your reply.
The PDF file is received from a third party. I need to input the data from the graph into Excel. Currently we input the data by measuring the graph which as you can imagine is very time consuming and inaccurate.
RE: Graph data copies from a PDF
Dear Rashmi,
There is different solutions to extract data from PDF. Try Adobe Reader. If the data are added as table, you can copy and paste to Excel. If Photocopy you can't.
There is different software which can do what you want.
Please see link below
http://www.theguardian.com/technology/askjack/2010/feb/15/convert-pdf-to-excel
You can also do it using Adobe Acrobat
I hope you will find a solution which will do it for you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Read more: https://www.stl-training.co.uk/post-34560-formula-shows-quarters.html #ixzz2wE8kbKnu
