Jul 28 2017
06:47 AM
– last edited on
Jul 25 2018
09:39 AM
by
TechCommunityAP

Jul 28 2017
06:47 AM
– last edited on
Jul 25 2018
09:39 AM
by
TechCommunityAP

I will attach three images. The first is this combo chart, but as you can see, the months are in reverse chronological order.

However, attempting to flip all data by selecting the “Categories in reverse order” button in the formatting of the x-axis only flips one of the two datasets, and not both:

I’m not quite sure what I’m doing wrong, here. Googling hasn’t helped me.

My dataset in question:

Jul 28 2017 07:17 AM

Jul 28 2017 07:17 AM

Solution

Hi Robin,

On your initial graph after you added secondary vertical axis add secondary horizontal axis, it will repeat the primary one and will be on the top of the graph. After that select primary horizontal axis, reverse it. Next select secondary horizontal axis, reverse as well. Select secondary horizontal axis and delete it.

Jul 13 2020 11:36 AM

Jul 13 2020 11:36 AM

Mar 22 2022 11:46 AM

Mar 22 2022 11:46 AM

Mar 22 2022 12:08 PM

Mar 22 2022 12:08 PM

Under ‘Vertical axis crosses’, select ‘Maximum axis value’.

Mar 22 2022 12:23 PM

Mar 22 2022 12:23 PM

Mar 22 2022 12:44 PM

Mar 22 2022 12:44 PM

Do you use a right-to-left language such as Arabic?

You are watching: Reversing the x-axis on a Combo chart (2 different y-axes) only flips the values for one of the two?. Info created by GBee English Center selection and synthesis along with other related topics.