30-Day Chart, updated daily

[e119687]

I have a number of very simple charts that I must update each day.

A sample is attached.

I simply auto-fill the top row to create the "new day" and then paste in the numbers for the charted rows for that day.

The chart needs to display only 30-days of data. So each day, I must manually modify the chart "Select Data" options to drop off the oldest day and add the new day.

I.e. Today's chart was from 2-Jan to 1-Feb. tomorrows Chart will be from 3-Jan to 2 Feb, the day after from 4-Jan to 3-Feb.

Is there a simple way to automate this shifting of the 30-day cycle?

 

[Nebu]

Hi:

Follow this link for dynamic charts

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Thanks

 

[Hui]

I have added 3 Named Formula, Refer to the Formula, Name Manager Tab
Then change the Chart to reference the Named Formula instead of the ranges
See attached

 

[e119687]

I have added 3 Named Formula, Refer to the Formula, Name Manager Tab
Then change the Chart to reference the Named Formula instead of the ranges
See attached

Absolutely awesome solution! Exactly what I was looking for.

Thanks so much!

Hi:

Follow this link for dynamic charts

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/

Thanks

Thanks for the link to the dynamic charts, I will poke around and see if I can improve my skills.