G Guest Feb 22, 2006 #1 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?
A Andy Pope Feb 22, 2006 #3 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
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
