• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Rolling Range in Chart Excel 2003

D

Dain

New Member
Hi-


I am making a chart that I would like to pull daily. My data set will increase every day and I'd like to keep all my data. However, for the chart, i'd like my range to only give me the last 30 days worth of data, not the whole set.


Any ideas?


Thanks

Dain
 
Check out the technique described here:

http://peltiertech.com/Excel/Charts/DynamicLast12.html


Name of article is about months, but you could just as easily make it for 30 days.
 
That's awesome - thanks Luke - found a work around but am changing it to this as much more efficient.


Work around was to write a second macro that selected the correct range from the whole data table and then pasting that selection onto a separate sheet (always in the same manner) where the charts were then driven from.


Thanks again - your way much much better-


Dain
 
You must log in or register to reply here.
Back
Top