+ Reply to Thread
Results 1 to 5 of 5

X-Axis on CHart not Showing Complete Data Set

  1. #1
    Registered User
    Join Date
    05-11-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2003
    Posts
    4

    X-Axis on CHart not Showing Complete Data Set

    Hello,

    I'm having an issue with a very basic chart where I unable to get it to show my complete data set in Excel 2010. The chart is showing a comparison between a pre-assessment and a post-assessment for a group of 28 students. However, the chart is only showing data up to Student #23. I have tried adjusting everything I can possibly adjust and cannot get it to show the remaining 5 students. I've searched the web and it seems others have had this issue, but I have not seen a clear response on how to resolve it. Any suggestions?
    Attached Files Attached Files

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

    Re: X-Axis on CHart not Showing Complete Data Set

    I opened your file and looked at the range definitions for both series. Both series are using the range B2:AC2 for the horizontal category axis range, and both series are using column B:X for the values range. Because the values ranges are only extending to column X, Excel stops displaying the chart at that category (student 23). I edited the series definitions so that the values ranges extended to column AC, and the values for students 24 to 28 appeared in the chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    5,922

    Re: X-Axis on CHart not Showing Complete Data Set

    I just clicked inside the chart, right clicked and hit select data from the list, then went to the chart data range and went to sheet1 and highlighted cells B2 through AC4, hit ok, then did same and for the legend entries selected edit and for the first one (Series 1) I selected A3 and for the second one (Series 2) I selected A4, then ok and it shows all 28 students now.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  4. #4
    Registered User
    Join Date
    05-11-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: X-Axis on CHart not Showing Complete Data Set

    OMG! Thank you so much! That has been driving me crazy!

  5. #5
    Forum Expert Sambo kid's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    5,922

    Re: X-Axis on CHart not Showing Complete Data Set

    glad I could be of some help, AND thank you for the rep!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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