#Openoffice calc graph not updating how to#
#Openoffice calc graph not updating series#

At this point, though, you need to make a decision. Generally speaking, I typically see charts like this with the smaller of the two ranges assigned to the left axis and the larger assigned to the right axis, but, again, it is entirely up to you which way you choose to go. You’re going to change the scale of one of the two y-axes, but which axis do you want to change? There isn’t a right or wrong answer here. The next steps are pretty straightforward, but before you do them, you should pause and think for a second so you don’t have to go back and undo what you’re about to do. In the window that pops up, you’ll see a second column labeled “Secondary Axes.” You want to select “Y axis.”Ĭlick “OK” and you’ll see that a second y-axis has been added to your chart on the right side using the same metric as the left side: 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.

#Openoffice calc graph not updating series#

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.

#Openoffice calc graph not updating how to#

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.