+ Reply to Thread
Results 1 to 4 of 4

Chart source data gets longer every day? How can I make the chart follow it down?

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Chart source data gets longer every day? How can I make the chart follow it down?

    I have an external add-in to Excel that prints data every day, which increased the data range by 1 cell per day.
    I have charts running off this data, but the frustrating thing is, every single day I have to drag down the source data range so that the chart includes the new information. I have attached an Excel file to help explain this. Does anyone know of a way that I can somehow make the chart automatically refresh to include the new data/rows.

    Thanks so much, this drives me crazy.

    excel help.xlsx

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Chart source data gets longer every day? How can I make the chart follow it down?

    Sounds like you need a dynamic chart:

    http://peltiertech.com/Excel/Charts/...html#DynColCht
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Chart source data gets longer every day? How can I make the chart follow it down?

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

    Thanks, i tried this but unfortunately when I get to the stage where I have to click on the chart, and write the named range in the SERIES: bit of the chart in the formula, I type in the name, but it obviously doesn't like it as it doesnt let me escape the formula bar. Any idea? thanks

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Chart source data gets longer every day? How can I make the chart follow it down?

    An easier method to bypass dealing with named ranges would be to convert your data range to an Excel Table. You can do this by highlighting the entire range, and pressing CTRL+T. Then adjust your chart to include the entire range. Now every time you enter in data, the chart will update accordingly.

    If you do not want to go this route, there are other, slightly more complicated options as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Chart Source values showing as zero in chart
    By Bernieboo62 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-29-2014, 10:53 PM
  2. To get Chart Data Source of powerpoint chart by excel VBA
    By imran0305 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-13-2014, 07:13 AM
  3. Chart not updated until chart sheet opened following source data update
    By untilyesterday in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-24-2013, 12:27 PM
  4. Replies: 6
    Last Post: 12-09-2006, 05:27 PM
  5. [SOLVED] My chart no longer responds to data change, why?
    By Squiddle in forum Excel General
    Replies: 0
    Last Post: 06-30-2006, 06:20 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1