+ Reply to Thread
Results 1 to 3 of 3

Line Chart Question

  1. #1
    Registered User
    Join Date
    09-30-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    8

    Line Chart Question

    Hi doing a school project. How do I fix an x axis to display text that shows just the month once. For example using the below data how do I have the axis say Nov-01 Dec-01 Jan-01

    I want the tick line just to be on that day.

    Thank you so much!

    11/1/2005 34.925
    11/2/2005 35.668
    11/3/2005 35.67
    11/4/2005 36.45
    11/7/2005 36.573
    11/8/2005 36.593
    11/9/2005 37.063
    11/10/2005 37.263
    11/11/2005 37.263
    11/14/2005 37
    11/15/2005 36.963
    11/16/2005 36.165
    11/17/2005 36.518
    11/18/2005 36.623
    11/21/2005 36.743
    11/22/2005 36.798
    11/23/2005 36.95
    11/24/2005 36.875
    11/25/2005 36.875
    11/28/2005 36.835
    11/29/2005 36.7
    11/30/2005 37.258
    12/1/2005 37.755
    12/2/2005 37.878
    12/5/2005 38.32
    12/6/2005 38.293
    12/7/2005 38.06
    12/8/2005 39.11
    12/9/2005 39.21
    12/12/2005 39.098
    12/13/2005 39.388
    12/14/2005 39.37
    12/15/2005 39.488
    12/16/2005 39.683
    12/19/2005 39.873
    12/20/2005 40.433
    12/21/2005 40.01
    12/22/2005 40.495
    12/23/2005 40.355
    12/27/2005 40.63
    12/28/2005 40.395
    12/29/2005 40.303
    12/30/2005 40
    1/2/2006 41.243
    1/3/2006 41.503
    1/4/2006 41.988
    1/5/2006 41.95
    1/6/2006 41.815
    1/9/2006 41.445
    1/10/2006 41.24
    1/11/2006 41.133
    1/12/2006 41.583
    1/13/2006 41.015
    1/16/2006 41.485
    1/17/2006 41.44
    1/18/2006 41.09
    1/19/2006 41.755
    1/20/2006 41.41
    1/23/2006 41.458
    1/24/2006 41.468
    1/25/2006 41.365
    1/26/2006 41.475
    1/27/2006 42.42
    1/30/2006 43.798
    1/31/2006 43.2

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,408

    Re: Line Chart Question

    If you select the x-axis values on the graph and then right-click, one of the options is Format Axis, and from there you can change the tick intervals and other things.

    I find with most graphs you can right-click on a particular area and get a pop-up which is relevant to that area.

    Hope this helps.

    Pete

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

    Re: Line Chart Question

    Becareful of your choice of axis type. Although you have dates you are missing datapoints for the weekends. The line will be interpolated between Friday and Monday.
    Depending on what you are doing this may or may not be an issue.
    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. Line chart with markers question
    By ckosman in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-26-2013, 02:56 PM
  2. Line chart with markers question
    By ckosman in forum Excel General
    Replies: 3
    Last Post: 04-25-2013, 03:06 PM
  3. Line chart with markers question
    By ckosman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2013, 03:06 PM
  4. Line Chart Question - break in line for blank cells
    By JonPugh in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 12-09-2009, 09:39 AM
  5. [SOLVED] Line - Column 2 Axes chart question
    By mktg@vzw in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-14-2006, 05:25 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