Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have prepared a line chart, which shows two values, which should be compared. Because these values are far apart, I have used split axis. As you can see, the min and max values of the respective axises overlap. How can I avoid this?
Any help is welcome!
Well, usually people put labels for one of the axis on the left and the labels for the other on the right. That way no overlap is possible. I'd seriously consider two charts above one another. That will still make it fairly easy to make comparisons between them. Alternatively, if the comparison is so important then normalize them both so they show the relative change against an index value. Since you're then displaying ratios instead of absolute values the two lines can share a common y-axis.
How can I avoid this?
Simple. Never use split axes. Always create two separate charts instead. There's no good use case for split axes. The alternatives are always better to interpret and understand.
Hahaha!! Good answer, but not exactly what I wanted to read.. The reason I want these graphs in split axis, is that there is a lot of control involved in setting up these graphs, and I'm too lazy to do it all twice.. No seriously, these graphs represent insurance reserve and IBNR stats, which should be closely compared for several years. Is there no way to avoid the overlap when I insist in using split axis?
Well, usually people put labels for one of the axis on the left and the labels for the other on the right. That way no overlap is possible. I'd seriously consider two charts above one another. That will still make it fairly easy to make comparisons between them. Alternatively, if the comparison is so important then normalize them both so they show the relative change against an index value. Since you're then displaying ratios instead of absolute values the two lines can share a common y-axis.
Your last sentence made sense. Thanks!!