Home › forums › Chart Support › primary/secondary y-axis gridlines do not match for same ratio
Tagged: gridlines, max, min, secondary y-axis
I can’t get my primary and secondary Y-axsis gridlines to match.
Both have the same amount of gridlines (ie ratio),
min = 1, max= 101, interval = 10
range => max – min => 101 – 1 = 100
gridline count (ratio) = range/interval = 10
min = 0, max= 200, interval = 20
range => max – min => 200 – 0 = 200
gridline count (ratio) = range/interval => 200/20 = 10
It seems to have something to do with the minimum/maximum…
Because, weird enough the first gridline of my primary y-axsis doesn’t start at 1 and end at 101.
When i use some other data the lines do match.
Gridlines are drawn at every interval. Even when minimum and maximum are set to 1 and 101 respectively and interval to 10, the labels are being shown at 10, 20, 30, etc and not at 11, 21, 31, etc – controlling the starting point of the label is not available as of now. Because of this, the gridlines of primary and secondary y-axes don’t overlap.
You must be logged in to reply to this topic.