Chart help Hide Months

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
[email protected]
"[email protected]" <[email protected]> wrote in
message news:[email protected]...
>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?

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

[email protected] wrote:
> 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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info