SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2271378%22%20slang%3D%22en-US%22%3EAlign%20zeros%20horizontally%20for%20vertical%20primary%20and%20secondary%20axes%20(combo%20chart)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2271378%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20anyone%20assist%20with%20how%20to%20align%20vertical%20primary%20and%20secondary%20axes%20(on%20a%20combo%20chart)%20so%20that%20the%20zeros%20are%20in%20line%20horizontally%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2271378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies
best response confirmed by Bryan_Starkey (New Contributor)
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 -80Primary 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:

Screenshot 2021-04-14 at 06.24.03.png

@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!!