Forum home » Delegate support and help forum » Microsoft Excel Training and help » Graphs
|
|
|
The UK's most regular 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. |
Graphs
Resolved · Urgent Priority · Version 2007
Reply Tue 18 Jan 2011, 12:25Delegate Alan said...
Alan has attended:
Excel VBA Intro Intermediate course
Graphs
How can you copy a graph in one spreadsheet, but copy the link of that graph to another spreadsheet? So when you change details of the oroginal data the graph on the other spreadsheet updates.
There was a option on the 2003 version to paste special links however in the 2007 version this option is greyed out and therefore not available.
For upcoming training course dates see: Pricing & availability
RE: Graphs
Hello Alan
Thank you for your question regarding graphs.
It is possible to copy linked charts. Once your chart is created in one spreadsheet, if you right-click over the chart (make sure its over the white background and not over part of the chart columns etc...).
Select Copy, go to the other workbook, and choose paste. If you want the chart as a chart sheet, then with chart selected in new book, look at button in top right, called Move Chart. Charts are dynamically linked so changes made in original spreadsheet will update other charts too.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Mark
Microsoft Office Specialist Trainer
|