+ Reply to Thread
Results 1 to 2 of 2

Line graph with 2 y-axis not showing correct x-axis labels

  1. #1
    Forum Contributor
    Join Date
    05-26-2004
    Location
    Halifax, UK
    MS-Off Ver
    Office 2016
    Posts
    260

    Line graph with 2 y-axis not showing correct x-axis labels

    I've got a line chart with 3 data series. One has much larger values than the others so I've put it on the secondary y-axis. However, when I do this it messes up the y-axis category labels. They are supposed to be dates running from 1st April 2020 to end of June 2020, but when I add the secondary y-axis they change and start from 1st January 1900! The chart is supposedly still looking at the same range for the labels but isn't reading the correct ones in once I put the secondary axis on.

    Does anyone know how to fix this?

    TIA :-)

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

    Re: Line graph with 2 y-axis not showing correct x-axis labels

    It is difficult to debug based solely on your text description (a sample file would help us help you). My guess is that one or more data series is not using the correct range for the horizontal category axis labels. I would pull up the Select Data dialog, select each data series, and see what each is using for the category axis labels. For any that are not using the specified range, edit the category axis range so that it is using the correct range.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. changing axis in line graph - label axis should be on y-axis
    By Falimus in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-24-2020, 04:56 PM
  2. Replies: 6
    Last Post: 05-19-2016, 05:35 PM
  3. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  4. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  5. Graph X axis (multi-level category labels) not showing all the text
    By mclhone in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2013, 09:33 PM
  6. Replies: 2
    Last Post: 05-16-2010, 11:23 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 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