You’ll get a context menu with the option “Insert/Delete axes…” Select that: Then, select the chart area by clicking on one of the axes (left or right doesn’t matter) and then right-click it. Once you have your chart with two data series complete, now it’s time to add a second y-axis with a different scale.įirst, click on your chart then double-click it to open chart editing. To begin with, go ahead and create your chart with at least two data series, as I have shown in other tutorials, like this one. What I want to do in this tutorial is to illustrate how to add a second y-axis on the right side of the chart that uses a different scale that is more appropriate for the number of temples. Thus, the maximum value is 4,000 and the minimum is 0. LibreOffice Calc automatically creates the scale used for the y-axis based on the scale of the larger of the two data series, in this case, the number of stakes. The chart shows that stakes have increased, but it looks like the number of temples has barely moved. If I plot them both on the same chart with the same y-axis (that’s the vertical axis), the number of Mormon temples is going to look really small and I won’t be able to see the variation over time in the number of temples, like this:
However, the number of Mormon temples is in the hundreds while the number of Mormon stakes is in the thousands. (I’m a sociologist who studies religion you’ll just have to go with my examples.) Let’s say I want to see whether the number of Mormon temples being built aligns with the number of Mormon stakes (akin to a Catholic diocese) that are organized over time. While a bit technical, it’s occasionally useful to plot multiple data series that have very different scales in the same chart.
0 kommentar(er)
