Thread: Creating a Macro to edit charts

I would like to create a Macro to speed up a tedious process.

My charts are updated weekly as new data is entered. I would always like the chart (generally combined bar and line) to show 13 weeks of data. Currently, I right click on the chart, chose the "select data" option and then manually adjust the legend entries and horizontal axis labels to reflect 13 weeks of data. This is repeated for each data series on every chart.

Is there an easier way to do this?

I hope I was clear. Please ask if you don't understand the process.

i could suggest you an alternate way to solve the process but dont know whether you will like it or not.

Let your charts pickup the data from the same range and instead of changing the ranges change the data every week. There are again many ways to change the data every week.

You can write some macros or even simple vlookup types formulas which will change the data in the range in such a manner that your oldest data will be moved out of the range and the latest data will be populated in the range and hence your chart could be updated easily. Try it if it works for you.

Wow, thanks Teylyn!