+ Reply to Thread
Results 1 to 4 of 4

x Axis Data Problem on the Line Chart

  1. #1
    Forum Contributor
    Join Date
    01-16-2015
    Location
    Istanbul
    MS-Off Ver
    Office 365
    Posts
    922

    x Axis Data Problem on the Line Chart

    The third chart which is below one is mine.

    There, the data on the x Axis is different than others. As you see other charts have years as data of the x Axis.

    How do I make it like those?
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: x Axis Data Problem on the Line Chart

    Is this different from your other thread...
    http://www.excelforum.com/excel-form...to-serial.html
    ?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

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

    Re: x Axis Data Problem on the Line Chart

    Yes, it is different - this time you want to change the Data Source to point to your column of dates (years). Similar to before, click on the chart, then right-click and choose the Select Data option, then in the right-hand box where it says Horizontal Axis labels click Edit, then move the cursor to select the cells where your years are (i.e. =Sheet1!$B$4:$B$17), then click OK, and OK again. You might want to play about with Format Axis (see your other thread) to get the right font and alignment.

    Hope this helps.

    Pete

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: x Axis Data Problem on the Line Chart

    Thanks for the input Pete

+ 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. Problem with Axis on line chart
    By stal in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-04-2014, 05:36 AM
  3. [SOLVED] Double Line Chart (different number of data on x axis)
    By Jovica in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-30-2013, 03:10 AM
  4. Line chart Y axis with non fixed data set
    By calabresino in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-06-2013, 07:30 AM
  5. Replies: 3
    Last Post: 02-05-2012, 10:04 AM
  6. problem/question with area or line chart for x axis
    By stavpal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2007, 04:07 PM
  7. Replies: 2
    Last Post: 09-22-2005, 06:57 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