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

How do I to automatically update a chart?

C

cchuat

New Member
Say I have a chart made out of a range of data of the last 50 days, how do I have the chart updated each time when a new day's data is added to the end of the existing range and in the process, the new chart will display only data from the 2nd to the 51st day while omitting the 1st day's, so that the chart will continue to display only 50 day's of data?
 
Hi ,


There is an earlier question on this topic , where the number was the most recent 13 months.


Your problem should be resolved by using the same techniques posted there , changing the instances of 13 to 50.


http://chandoo.org/forums/topic/using-counta-and-offset-formulas-for-13-month-dynamic-graphs


Narayan
 
Thanks a million. I am not very good at this and am trying very hard to digest the solution. I do appreciate your guidance very much!!
 
I am heading no where, would appreciate if anyone can help by showing me the step-by-step way to set up a dynamic range/graph. Pardon my shallow knowledge in EXCEL.


cchuat
 
Cchuat


A better link is: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/
 
Hui


Thank you. I was actually referring to that link you posted most of the time but have not been successful in setting up my charts.
 
Do you want to send me a file with some details of what your after?

Click on Excel ninja

Link at bottom of page
 
Hi Hui,


Glad you could help. I have just sent the file over to you via email. Thanks a million!!!


Rgds

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