+ Reply to Thread
Results 1 to 6 of 6

Excel chart not showing all data

  1. #1
    Registered User
    Join Date
    08-16-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Excel chart not showing all data

    I was wondering if someone could help.

    I have a weekly spreadsheet but it's only showing my weekly figure to 23 December 2022. When I double check my data selected the range selected is corrected and is to 27 Jan 2023. Have tried deleting some of the old history but that doesn't make any difference.

    I'm using Office 365.

    ThanksSnipImage.JPG

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

    Re: Excel chart not showing all data

    Difficult to debug from a picture. Can you upload a sample file?

    If I had a sample file, things I would check:

    1) chart data ranges (it appears you have already done this, but I would check them again).
    2) axis settings. Especially for a date axis, is it set to only show up through 23 Dec?
    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
    08-16-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Re: Excel chart not showing all data

    I've uploaded the file and hopefully you can see it thanks

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

    Re: Excel chart not showing all data

    I only see the picture in the OP. No file. Be sure you are following the directions in the yellow banner at the top of the page to attach your sample file to the post.

  5. #5
    Registered User
    Join Date
    08-16-2017
    Location
    Australia
    MS-Off Ver
    2010
    Posts
    7

    Re: Excel chart not showing all data

    Flow.xls

    Hopefully this works

  6. #6
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Excel chart not showing all data

    HI
    The dates are not the timeline. The last THREE refer to the month of January 2022.
    Maybe you meant 2023?
    HI,
    Mario

+ 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. [SOLVED] chart not showing proper data.... How do I make a chart
    By ChrisTag1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-19-2019, 02:54 PM
  2. Replies: 1
    Last Post: 04-26-2018, 10:43 AM
  3. Excel 2010 - Data and dates not showing in line chart.
    By TomMan in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-08-2014, 07:31 AM
  4. [SOLVED] Surface Chart Depth Axis showing all Data Series' on top of each other (Excel 2007)
    By enginezzz in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-26-2013, 11:22 AM
  5. Replies: 2
    Last Post: 06-07-2012, 09:20 AM
  6. [SOLVED] excel chart plot area not showing data
    By samm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-25-2005, 07:05 AM
  7. [SOLVED] Excel chart data labels showing % change instead of value?
    By MFritz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-20-2005, 10:05 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