Align zeros horizontally for vertical primary and secondary axes (combo chart)

[Bryan_Starkey]

Can anyone assist with how to align vertical primary and secondary axes (on a combo chart) so that the zeros are in line horizontally?

[#2 · Accepted solution]

@Bryan_Starkey That's tricky, as the objective of combo charts (in my understanding at least) to display data series, roughly in the same area of the chart. You need to play around with the bounds for one or both axis, in order to match the zero's as in the picture below.

Primary lower bound set to -80

However, changing the underlying data points will mess-up everything and you'll have to redo the scaling of the axis.

The default chart for this example would look like this, by the way:

[#3]

@Riny_van_Eekelen Thank you so much - that has done the trick!!

You are right in that on a combo chart ideally both measures supposed to follow a common base, which they until....unless they don't go to plan!!