Use VBA to modify Chart series data

[noideawhatiamdoing]

Hi,

I have an excel model that I have built that displays YTD data on a weekly basis in the form of graphs. There are a 7 of different tabs, 5 are for each individual site, 1 is a combined tab, 1 is for comparisons and the final one displays retail data.

My question is whether or not it is possible to use VBA to modify the series data for these graphs to only display the number of weeks in the selected YTD period. With this in mind the number of series could increase as well as decrease, dependent on the final week number of the period selected.

Any advice would be greatly appreciated as it is very cumbersome to filter 58 graphs.

Thanks,