Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Ephrata, Washington, USA
    Thanked 0 Times in 0 Posts

    Chart update with new data (2003)

    A user asked me how to get a trendline to ignore zero values in a chart he made. When I looked at the chart, I think what he needs is to have the chart automatically update to include new data as he adds it. Right now the data is in range B2:J77. Each month, a new column is added to the data. He has included 24 months of (future) columns to the data range, which show as blanks in his chart (and skews his trendline). How can we set it up so that when he adds a column to the range (instead of including a bunch of blank columns), the chart will update with the new column of data?

    I searched the bb and found a thread on dynamically updating a chart, and Hans included a button. It was pretty cool. I tried modifying it to our needs, but I just can't figure out the code. I am "code illiterate.' The button idea would work fine, if I could figure out how to modify it for our data. Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Chart update with new data (2003)

    You don't really need code. See attached example. Add data in column G, H etc. and see how the chart updates itself automatically.
    Click on the chart, then select Chart | Source Data and activate the Series tab to see how the source data for the series are defined.
    Click outside the chart, then look at Insert | Name | Define to see how the dynamic ranges are defined.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts