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