Gabriel Peterlini on 13 Jun 2018 21:10:28
When using a "Line and Stacked Column" chart you can use the option to align to zero so both axes start at zero, but there's no way to align all other values.
For example: One of the columns on a chart corresponds to a value of 98K and you want to have a dot on line above it corresponding to 100K, that doesn't necessarily happen even when aligning the start of both axes to zero since the increment is different on both axes, therefore you end up with the column going over the dot because the value of 100K on the left axis is corresponding to approximately 120K on the right axis.
- Comments (4)
RE: Ability to align Y axes values when aligning to zero.
We require not only the zeros to be aligned between the primary and secondary Y-axis, but also the maximum values, and thereby the entire range/grid over which the Y-axes spans.
RE: Ability to align Y axes values when aligning to zero.
'@Schreef, it looks like it does, but it doens't. Look at the actual values in the chart of the second Y Axis
RE: Ability to align Y axes values when aligning to zero.
That isnt the way around it, that is the exact purpose of that feature.
RE: Ability to align Y axes values when aligning to zero.
Found a way around it.
Under the "Y Axis" customization, turn off the "Show Secondary" option, this makes it so the dots align to the same axis as the columns.