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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks