3
I often find myself copying and pasting worksheets in order to show the same analysis for different sets of data. This includes graphs. It's irritating having to 'select data' for every data series, error bars, etc. for every data set.
Once I have created a graph for one worksheet, my choices are:
- Copy the graph to another worksheet. Use 'select data' for every part
- Copy the entire worksheet, then replace the data
I would much prefer to be able to see the XML (or whatever) representation behind the graph and be able to do a find-and-replace on the worksheet names/column names. The Excel interface gets in the way a lot and doesn't make it easy to change the graph repeatedly (particularly for error bars).
Is there some textual representation of objects like graphs I can edit? (I'd rather not mess around with extracting the xlsx file and editing the XML files in a text editor).
You should be able to modify your charts using VBA. Also, if applicable, modify the chart source tables instead of the charts. – mtone – 2013-02-03T18:44:59.187