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.
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
