2 Y axes in one chart / graph (Creating a chart with 2 different scales) Microsoft Excel You may wish to have two different measurements in one chart in
Page 1 of 2 Produced by Massey University Library Information Commons 2 Y axes in one chart (Creating a chart with 2 different scales) Microsoft Excel
the Line – Column on 2 Axes chart type, as shown in Figure 1 Excel will take care of formatting the chart with two axes and will place the last series as
and enter the y-coordinate in B1 Repeat for the other five points You Excel window should look like this: 2 Use your cursor to highly the columns and
26 sept 2018 · Those two sets of data have two Y axes with two different scales -- the secondary axis for their chart in most versions of Excel using
Each option shows different layouts that change the way graph components (X axis Y axis) are laid out Example: Layout # 1 adds placeholders for a chart
For small amounts of data, a spreadsheet like Excel is a good way to plot and down the control key (command on a Mac) then do the same for the y-axis
We want to plot this discharge data on a secondary y axis so that we can see the data clearly Double click on the orange line on the graph and a 'Format
(b) A superimposed Microsoft Excel chart The red line is plotted according to the left and the blue according to the right y-axis
A secondary-axis is useful when two data series have very different ranges of values It is inappropriate in the current case When a chart has a secondary y-