• 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.

Display rolling 12 months of data automatically in a graph

j_sun

Member
Hi All,

In this "How-To" article I learned a ton of shortcuts to make my graph creation easier:


http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/


I'm getting very lazy now. Is there an easy way to always have the graph display the last 12 months of data even though the underlying table has over 2 years of data points in it?


I know the easiest solution would be to delete the oldest entry every time I add a new one. The problem is that my boss loves to look at data and requests that the source table have as much data as possible.


Thanks!
 
I think this article would be perfect for you:

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