+ Reply to Thread
Results 1 to 6 of 6

I added data to my data series but it doesn't load in graph. Please help

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    32

    I added data to my data series but it doesn't load in graph. Please help

    Hello all,

    I have added data for the period of 1/1/2020 to 3/31/2020, and adjusted the cells in the graph.

    Can someone advise or have a look at my spreadsheet to see how come it(the two lines and area) does not work?

    I would like to have the axes adjust for the range each time I update the raw data.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: I added data to my data series but it doesn't load in graph. Please help

    Hi cyruschan,

    I'm concerned that you have two column heads named exactly the same thing of "Dates". Perhaps you chart can't discriminate between the two. Rename one of them to DateTotal and rebuild your chart.
    I couldn't find the range that you missed but could rebuild the chart easily enough. If you are going to continue to add dates and values then you might a Dynamic Named Range for your data.
    https://www.ozgrid.com/Excel/DynamicRanges.htm
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    03-26-2014
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: I added data to my data series but it doesn't load in graph. Please help

    my graph on the right side. Please take a look as my updated data is not populated into the graph(starts around cell J6).

    Please advise, thanks.
    Attached Files Attached Files
    Last edited by cyruschan; 04-13-2020 at 09:05 PM.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: I added data to my data series but it doesn't load in graph. Please help

    Hi cyruschan,

    Click on your chart's x axis dates and look at the "Format Axis". You have the minimum date set to April 2019 while your data goes back to Jan 2018. You fooled Excel charting tool!! I'm using Excel 365 and you are using 2003? They have changed the charting tool a few times since 2003. Time to upgrade? See what my 365 version has saved. See if your 2003 chart looks now that I've made the min date to 2018.
    Chart Min Date Axis problem.xlsx

  5. #5
    Registered User
    Join Date
    03-26-2014
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    32

    Re: I added data to my data series but it doesn't load in graph. Please help

    what changes did you make? I make the axis adjustment to my version in excel 2020 but the graph does not update. Do you know why this may be?

  6. #6
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: I added data to my data series but it doesn't load in graph. Please help

    I think you have your minimum date on the x axis set in april 2019 but the date range of the data starts in Jan 2018. Find the dialog that allows you to set the min x axis range. I have a different dialog display for the current 365 Excel. Here is exactly what I did.

    1. click on the dates under the graph which is the X-Axis. Keep clicking until the dates are selected with a box around only the dates.
    2. Right click in this selection and then on "Format Axis..." in the dropdown.
    3. In the "Format Axis" Dialog I changed an item called: Bounds: Minimum to 1/1/2018 and pressed Enter.

    The above fixed the problem of your chart data overwriting the table to the left. I have no idea where these dialogs show up on your version of Excel.

+ 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. Adding multiple data series on bar graph with line graph on top
    By JPRICH16 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-27-2019, 04:43 AM
  2. 3D Graph to Auto expand with added Series
    By coreytroy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-12-2012, 09:39 PM
  3. line graph with multiple data series vs. time/date leaves out most data
    By Lee Collins in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2012, 10:54 AM
  4. [SOLVED] Added series not showing up on graph
    By Physicsboy in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-16-2012, 04:18 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. [SOLVED] automatically expand chart data series as data is added
    By jlarson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-09-2006, 06:35 AM
  7. [SOLVED] series graph -- one series being added to another series
    By rich zielinski via OfficeKB.com in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-30-2005, 02:06 PM

Tags for this Thread

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