Automate chart X-axis/data

[dave157]

I am preparing a template that will be used by many of our sites to prepare a
monthly Cost of Poor Quality chart. This is a stacked bar chart that depicts
the current month’s data plus the previous 12 months of data. Data is added
every month and I want the chart’s X-axis will roll every month to display
the current month plus the past 12 months. Any ideas how to accomplish this?

 

[Tushar Mehta]

Essentially, you want to show the last 13 months of data. Adapt the ideas at
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
particularly example 2
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu