Forum Discussion
Managing a Rolling Chart
I prepare a chart with monthly data. I want to continually add data to a worksheet and move the chart with the data looking at 12 months at a time. Previously I could add as many months as I wanted...
Does that mean that every month, you manually change the rows which should be part of the chart? This sounds cumbersome to me.
Why don't you build a dynamic table with only the last 12 months next to your big table with all months and then link the new table to the chart?
Why don't you build a dynamic table with only the last 12 months next to your big table with all months and then link the new table to the chart?