View original (French)

Excel vertical axis moves to the right

EmmCee -  
Malysou Posted messages 2 Status Member -
Hello!

So I'm usually not terrible with Excel (Office 2007), but right now it's giving me a hard time!

I've created a chart with a logarithmic scale on the horizontal axis, but my vertical axis automatically moves to the right of the chart, whereas usually, it stays in its place, on the left side of the chart.

Can someone help me solve this little problem and move the vertical axis back to the left side of the chart?

Thanks in advance!

EmmCee

4 answers

  1.
    Malysou Posted messages 2 Status Member 2
     
    I found a solution...
    We select the chart
    In the Chart Tools Design tab, select "Change Chart Type"
    In the "All Charts" tab, choose Combo Chart
    We can then select the secondary axis (since it’s always the secondary axis that displays on the right)
    Back in the chart, we can uncheck the primary vertical axis so that the one on the left does not display....
    2
  2. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    Right-click on the axis / the vertical axis intersection: automatic
    0
    1. FoufyNounite
       
      You need to select the other axis before performing this manipulation.
      1
  3. EmmCee
     
    Hello again,

    This (automatic) selection has already been made and my axis is still on the right side of the graph...

    Any other suggestions to solve my problem?

    I would like to point out that my values on the horizontal axis are all positive, so there’s no reason for the axis to be on the right side of the graph!

    EmmCee
    0
    1. Chaa1901
       
      Solution I just found:

      Right-click on the axis: Axis Format > Labels > Label Position = "Low"

      And the axis moves back to the left.
      5
  4. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    In this case, define the value of the axis where the vertical axis should be located.
    -3