Chart help Hide Months

[lmossolle]

I have a data sheet that has historical data, I only want to chart 13 months
instead of all the data. Is there a way to do this?

 

[Don Guillett]

hide em

 

[Andy Pope]

Hi,

If your data increase each month have a look at Jon Peltier's example of
dynamic named ranges for plotting last 12 months. Obviously make the
appropriate change for 13 months.
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Cheers
Andy