+ Reply to Thread
Results 1 to 3 of 3

Reverse X-Axis Data Left to Right (separately from the axis labels)

  1. #1
    Registered User
    Join Date
    02-04-2022
    Location
    Long Beach, CA
    MS-Off Ver
    Home & Student 2019
    Posts
    6

    Reverse X-Axis Data Left to Right (separately from the axis labels)

    I can't change the presentation order of the data plot.
    The dates currently run left to right from 12/20/2021 to 2/3/2022. That is the way I want it.
    But the data plot in the chart is backwards compared to the date labels on the axis.
    Toggling "Dates in reverse order" (Format Axis > Axis Options) changes the date order (and the y-axis position) but it doesn't affect the bars in the plot.
    This is a special chart that colors the up bars differently than the down bars. I can't remember where I found the template.
    So, currently the X-axis labels are in the order I want but the bars are backwards.

    Dell XPS 8940
    Desktop
    Windows 11
    Office Home and Student 2019
    Excel v. 2201 (Build 14827.20158)
    Attached Images Attached Images
    Attached Files Attached Files

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

    Re: Reverse X-Axis Data Left to Right (separately from the axis labels)

    Add the secondary horizontal axis back to the chart and then delete it
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    02-04-2022
    Location
    Long Beach, CA
    MS-Off Ver
    Home & Student 2019
    Posts
    6

    Re: Reverse X-Axis Data Left to Right (separately from the axis labels)

    Thanks for the reply.
    I solved the problem by dumping what I was doing and copying my data into your 2004 template 1299852b.xlsx‎ from page

    http://www.excelforum.com/excel-char...ine-chart.html
    Last edited by AliGW; 02-05-2022 at 10:16 AM. Reason: URL fixed.

+ 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. Reverse order of X-axis when using Primary & Secondary Axis
    By greentea in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-11-2019, 12:34 PM
  2. Replies: 0
    Last Post: 07-09-2015, 06:21 AM
  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. No x axis correlation when using 2nd y axis and reverse x axis
    By lorims in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-03-2015, 09:25 PM
  5. Replies: 3
    Last Post: 04-30-2014, 05:57 AM
  6. move y-axis labels on column chart from left to right side
    By Kaye in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-25-2013, 11:57 PM
  7. [SOLVED] hierarchical axis labels reverse chart
    By steve in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-07-2006, 04:15 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