Forum Discussion

Robin Bach's avatar
Robin Bach
Copper Contributor
Jul 28, 2017

Reversing the x-axis on a Combo chart (2 different y-axes) only flips the values for one of the two?

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:

 

  • 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.

     

     

  • 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.

     

     

  • AliMoezzi's avatar
    AliMoezzi
    Copper Contributor
    I have a simple scatter chart with reversed x-axis values. I want to move the y-axis from the right of the chart to left. Is that possible?
      • AliMoezzi's avatar
        AliMoezzi
        Copper Contributor
        Thank you for prompt response. This will keep the y-axis on the right side of the chart. I want the y-axis to move to the left.

Resources