How can I edit charts in multiple worksheets Excel 2010

[Rocky.Paredes]

Hello - I hope everyone is doing well this Friday afternoon.
I am hoping someone can help please.

- I have to edit 200 charts in an excel workbook.
- There is a chart on each worksheet.
- Normally to edit data I would select a range of tabs on the workbook but it will not let me make global changes to charts.

Is there a way to do this in Excel 2010?

- Example Sheet 1, Sheet 2, Sheet 3 each contain a chart.
- I would like to make the same change on each.
- In particular I am changing the range, changing the font size of the chart, and changing a legend.

Thank you for your very kind attention.

 

[SirJB7]

Hi, Rocky.Paredes!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, check this link, it might be a starting point:
http://chandoo.org/forum/threads/ch...et-with-thousands-of-sheets.11757/#post-68884

But depending on the chart types it might be a long and hard job. Good luck.

Regards!