+ Reply to Thread
Results 1 to 3 of 3

Horizontal Axis Labels not showing

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    24

    Horizontal Axis Labels not showing

    I am trying to show the 'seasons' (see attachment) as labels on my horizontal axis in this scatter plot in Excel 2010 with out success. It is only showing 'numbers' while, when the chart is selected, as in the picture, the seasons are shown selected. Any help is much appreciated!
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Horizontal Axis Labels not showing

    xy scatters can only take numerical values for both x and y axes. Why not simply use a standard line graph?

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Horizontal Axis Labels not showing

    Quote Originally Posted by NickyC View Post
    xy scatters can only take numerical values for both x and y axes. Why not simply use a standard line graph?
    Thanks for the reply! I was not aware of this. I did not like the sharp angles in line graphs but got around it by using the 'smoothed line' option in the 'line style'.

+ 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] modifying the Horizontal axis labels
    By Elainefish in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-16-2013, 05:02 PM
  2. trying to change the labels or names on horizontal axis
    By pwynkoop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-11-2013, 04:30 AM
  3. How To Get Y Axis Labels Horizontal?
    By mycon73 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-30-2011, 11:26 AM
  4. Horizontal axis labels in Bar Charts
    By jeskit in forum Excel General
    Replies: 2
    Last Post: 08-15-2011, 04:39 AM
  5. Two rows of labels on the horizontal axis
    By macaonghus in forum Excel General
    Replies: 0
    Last Post: 01-12-2010, 06:49 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