Results 1 to 4 of 4

Thread: One of two series in a line chart is in reverse order and doesn't match axis

  1. #1

    One of two series in a line chart is in reverse order and doesn't match axis



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a line chart that plots two series - one for vacancy and one for asking rate. When the chart displays, the vacancy displays as expected - matching the vacancy with the year. But the asking rate is in reverse chronological order (the opposite of how it should be, how the vacancy displays, and the y-axis displayed on the chart). I've included a snapshot of the part of the worksheet below. Basically, I want Series 2 (the red line) to flip horizontally to go in chronological order. By the way - some of the rows in the table above the chart are hidden, but are displayed in the chart below.

    Any suggestions on reversing just one series' plot order without changing the other parts of the chart display?

    Thanks

    Click image for larger version. 

Name:	excel chart issue.jpg 
Views:	286 
Size:	78.5 KB 
ID:	2610

  2. #2
    Thought I'd put in a copy of the excel worksheet as well since it'd be easier for someone to troubleshoot.

    excel chart issue excel.xlsm

  3. #3
    Acolyte Andy Pope's Avatar
    Join Date
    Mar 2011
    Location
    London, England
    Posts
    39
    Articles
    0
    Excel Version
    2016
    You need to enable the secondary horizontal axis in order to set categories in reverse, as you have done on primary axis.

    You will also need to set Vertcial axis crosses at maximum, which is also on the format dialog for secondary horizontal axis
    Cheers
    Andy

    www.andypope.info

  4. #4
    Thank you Andy. I thought this thread was long forgotten and had already rigged a fix by transposing my series 2 data in reverse order and pulling the chart data from that. Your advice works and I'll apply it in the future.

    Thx again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •