How can the last 12months on the x-axis auto update each month?
 

My chart sould always display the last 12 months and every month I have to
change the axis range so it displays the latests 12 months. I have seen this
being used before so I know it can be done. Can you please help?

How can the last 12months on the x-axis auto update each month?
 

http://peltiertech.com/Excel/Charts/DynamicLast12.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Faisal78" wrote in message
...
My chart sould always display the last 12 months and every month I have to
change the axis range so it displays the latests 12 months. I have seen
this
being used before so I know it can be done. Can you please help?