98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graph data copies from a PDF
Graph data copies from a PDF
Resolved · Urgent Priority · Version 2010
Mon 17 Mar 2014, 09:27Delegate Rashmi said...
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?
Mon 17 Mar 2014, 13:54Trainer Jens said...
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
Mon 17 Mar 2014, 14:16Delegate Rashmi said...
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.
Mon 17 Mar 2014, 16:08Trainer Jens said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Go to source of a cellThe default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell |
