How to set Secondary Axis to start at zero point on Primary Axis

[danhenshy23]

Hi,

I have a column chart with both negative and positive values. In the same chart I have a secondary axis which only contains positive numbers.

What I want is for the starting point of the secondary axis to be the zero point on the primary axis.

Currently the zero point on the secondary axis is equal to the lowest value of the primary, how do I go about changing this?

Thanks
Dan

 

[MartyS]

Do you mean something like this?

If so, set the Horizonal axis crosses on the Axis Value of 0

and make sure that you've set the Minimum and Maximum axis options to Fixed

In the example data I used, the Primary Axis data goes from a range between 0 and 100.

The secondary axis data goes from 0 to 5,000.


By setting the Secondary axis from -5000 to +5000, it can successfully cross at 0 on the X-Axis.

Hope this makes sense?

 

[danhenshy23]

Thanks, I think that should do the trick.

Is there any way to have the 0 to -5000 in the secondary axis not be visible?

 

[wanna_learn]

hi, how about something simple like selecting the axis you want to hide and just change the font to white?

 

[MartyS]

Thanks, I think that should do the trick.

Is there any way to have the 0 to -5000 in the secondary axis not be visible?

As far as I'm aware, that isn't possible - I think it's because it defeats the purpose of the axis.

If you're not going to be moving the chart around, you could put in a 'work-around' and Insert a Shape and place a rectangle over that part of the chart (removing the outer Line property and setting a Solid colour to the same background colour as the chart).

Or you could hide it completely, but that would hide what height of the secondary-axis bars meant - however you could then add data-labels.