+ Reply to Thread
Results 1 to 3 of 3

Scatter chart x axis labels not changing to appropriate values

  1. #1
    Registered User
    Join Date
    10-14-2014
    Location
    Imperial base, Endor
    MS-Off Ver
    2007
    Posts
    1

    Scatter chart x axis labels not changing to appropriate values

    I have made a scatter plot chart with three different series to plot, all with the same intended x axis values. Under data selection, I did specify a range for the data that should appear as the x axis category labels, but it will not change to those values (14 days, 21 days, etc...), and instead display 1, 2, 3, etc., on that axis. Format Selection when selecting those x axis labels also doesn't give me the option to use text. Screencaps attached, showing formatting box options I see and the ranges for data selection, note that in that box it DOES show the correct x axis values, though the chart does not... Using 2007.
    Attached Images Attached Images
    Last edited by Vbot; 10-14-2014 at 09:24 PM.

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

    Re: Scatter chart x axis labels not changing to appropriate values

    It can be hard to tell from a picture, but it looks like you have included the text string "days" in each value for the X values. This converts the entire cell to a text string, which Excel does not know how to use in an XY scatter plot. So Excel uses the count numbers (1,2,3,...) for the plotted X values.

    Is it necessary to include the "days" string in the X values? The way I do it is to just use the numbers (14, 21, 28, ...) for the X values.
    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
    10-14-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    2010
    Posts
    4

    Re: Scatter chart x axis labels not changing to appropriate values

    Hi VBOT,

    You won't be able to use the "14 days, 28 days" as your X-values on a Scatter plot simply because that's how Scatter plots work.

    A way around this which I have just tested is to instead create a Line Graph, then with formatting make the line have no colour

    Line Graph.png

+ 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. Add labels/titles to vertical axis of scatter chart
    By verwater in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-23-2013, 07:19 PM
  2. [SOLVED] Wrap category names (Y axis labels) of a scatter chart?
    By JayUSA in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2012, 06:39 AM
  3. XY Scatter: Changing Horizontal Axis Labels
    By smurray444 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-16-2007, 11:52 AM
  4. [SOLVED] Scatter chart with text labels as Y axis?
    By Charles Blaquière in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-01-2006, 11:45 PM
  5. XL2003 - Changing X-axis labels in XY Scatter...
    By Birmangirl in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-15-2005, 03:10 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