software

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?

hide em

--
Don Guillett
SalesAid Software

quot; gt; wrote in
message ...
gt;I have a data sheet that has historical data, I only want to chart 13
gt;months
gt; instead of all the data. Is there a way to do this?
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.
peltiertech.com/Excel/Charts/DynamicLast12.html

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

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info