View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kameel Kameel is offline
external usenet poster
 
Posts: 1
Default Remove old month from chart add new/no manual reference change

jan feb mar apr
10 20 30 40

I want to graph the latest 4 months without having to go in a change
refrences in the chart each month.

Next month
feb mar apr may
20 30 40 50

If I drag the last months across to pick up the formulas for the next month
I get 5 months on the graph instead of 4