+ Reply to Thread
Results 1 to 4 of 4

Scatter with line chart Axis text values are not appearing

  1. #1
    Forum Contributor
    Join Date
    05-04-2009
    Location
    ME
    MS-Off Ver
    Excel 2003,2007
    Posts
    157

    Scatter with line chart Axis text values are not appearing

    Hi,

    I'm trying to plot Scatter line chart rankings for 3 years. Rankings are like "A+,A,B+,B,C" but instead of these text values numbers appearing.

    Attached the same workbook, appreciate your support to resolve this..


    Regards,
    Nawas
    Attached Files Attached Files

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

    Re: Scatter with line chart Axis text values are not appearing

    A scatter chart needs numbers for the horizontal x axis, so it interprets text as numbers. When you want text/categories along the x axis, you can try a line chart instead of xy scatter.

    Select the chart -> change chart type -> line and see if that is what you are looking for.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    05-04-2009
    Location
    ME
    MS-Off Ver
    Excel 2003,2007
    Posts
    157

    Re: Scatter with line chart Axis text values are not appearing

    Thanks for your reply, but i'm looking for Bell Curve chart and in line chart the shape of the bell curve will not be the perfect.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Scatter with line chart Axis text values are not appearing

    As Mr Shorty suggested use a line chart, smooth lines and horizontal axis labels on tick marks.

    If the letters are not equally spaced then you can create additional series with the correct x and y value for each letter and use a data label showing series name in order to fake an textual axis
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ 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. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  2. [SOLVED] Add Year Values to X Axis in Scatter or Line Chart
    By sherylt13 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-08-2015, 05:21 AM
  3. Column and Scatter/Smoothed Line Chart - X-axis values appear in wrong place
    By Cheekybeelzebub in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2015, 09:33 AM
  4. Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  5. Replies: 0
    Last Post: 03-22-2012, 09:46 AM
  6. [SOLVED] text label in x-axis (scatter chart)
    By [email protected] in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2006, 05:50 PM
  7. Scatter Chart Axis as text C#
    By Pablo Villalobos via OfficeKB.com in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2005, 07:06 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