+ Reply to Thread
Results 1 to 3 of 3

Add Year Values to X Axis in Scatter or Line Chart

  1. #1
    Forum Contributor
    Join Date
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Add Year Values to X Axis in Scatter or Line Chart

    Hi All, hoping/guessing I have an easy one here. I have a basic line chart with a trend line (started as a scatter however I believe the Scatter chart uses intervals on the X axis?) showing the number of terminations on a monthly basis, for the last five years. To avoid showing 60+ categories on the X axis, I would at least like the years to show if possible.

    I tried to get creative by adding a column showing the year, however the chart still showed the data 60+ times, such as 2010 appeared 12 times.

    Is there a way to create this chart so the years show (once) between 2010 - 2015, underneath the data for all months?

    Thanks for any suggestions.

    Sheryl

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

    Re: Add Year Values to X Axis in Scatter or Line Chart

    What format is the x data -- numeric, date, or text?

    If you will enter you data for the x axis so that it is actual dates (see here for an explanation of date/time serial numbers: http://www.cpearson.com/Excel/datetime.htm#SerialDates ), then you should be able to use a date axis on a line chart (see here for a discussion of numeric, categoric, and date x axes: http://peltiertech.com/Excel/ChartsH...ValueAxis.html ). With a date axis, you should be able to control the "x axis division" to be every year, or every few months, or whatever you decide looks best.

    When your x data is text/categoric, you don't get much control over how Excel displays the x axis, and it can only be controlled in terms of "categories".
    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
    08-08-2015
    Location
    NJ
    MS-Off Ver
    2013
    Posts
    205

    Re: Add Year Values to X Axis in Scatter or Line Chart

    Thank you. That was an easy fix, thanks for the quick response.

    Sheryl

+ 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. 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
  2. Scatter chart x axis labels not changing to appropriate values
    By Vbot in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-14-2014, 10:54 PM
  3. Replies: 2
    Last Post: 11-02-2012, 05:21 AM
  4. Replies: 2
    Last Post: 06-19-2012, 06:50 PM
  5. scatter chart x axis doesn't display correct values
    By sthegreatone in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-30-2012, 11:07 AM
  6. Replies: 0
    Last Post: 03-22-2012, 09:46 AM
  7. Line chart - different Y axis values?
    By rsd886647 in forum Excel General
    Replies: 3
    Last Post: 03-20-2009, 11:25 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