+ Reply to Thread
Results 1 to 3 of 3

Chart not updating when new data is added

  1. #1
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Chart not updating when new data is added

    I have created a sheet with numbers in them for inputting on different days as you can see from my spreadsheet chart data has been inputted after the 20th Jan 2016 but does not show on the chart, all data seem to be in number format and not text, can you help
    Attached Files Attached Files
    Last edited by Willows59; 01-27-2016 at 07:13 PM.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Chart not updating when new data is added

    For some reason, some of the dates in column A are year 1900. Your chart is formatted so that the earliest date is 1 Jan 2016, so dates before that will not show up. I suspect that if you make sure that all of your dates are for 2016, they should show up correctly.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-01-2014
    Location
    Stoke on Trent
    MS-Off Ver
    Excel 2019
    Posts
    31

    Re: Chart not updating when new data is added

    Yes just tried it and that's sorted thx for your quick response

+ 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. Replies: 2
    Last Post: 10-16-2014, 08:57 PM
  2. How to automatically add new added row data to my chart PlotArea?
    By ScubaGuy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2013, 03:22 PM
  3. Replies: 3
    Last Post: 05-25-2012, 10:46 PM
  4. Formula so that Chart expands as data is added
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2010, 06:34 PM
  5. Data Series in Chart are added together?
    By jonnyt in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-23-2009, 01:09 PM
  6. Automatically updating source code when new data added
    By itregub in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2009, 05:58 PM
  7. updating added data from a number of spreadsheets to a master spreadsheet
    By reeceponse in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-14-2009, 12:54 AM

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