Charts for 6 months data

[Naveen N]

Hi ,

Had a general question on charts.

We create chart based on 6 months data and every month a new month gets added and older month gets deleted from the chart.

Need to automate this where in current months gets used in the chart and 6 months from current month gets used for chart data.

Month col1 col2 col3

Aug15 12% 20% 12%

Sep 15 22% 22% 14%

Oct15 11% 23% 12%

Nov 15 13% 24% 15%

Dec 15 13% 25% 16%

Jan 16 11% 30% 11%

From the above example, when Feb month report gets generated, FEB 16 rows gets added and AUG15 rows gets removed.

Please suggest the best approach to create the chart.

Regards,

Naveen N

 

[Luke M]

Hi Naveen,

Check out this tutorial here:
http://peltiertech.com/Excel/Charts/DynamicLast12.html

Example uses last 12 months, but you can easily change to only plot last 6 months.