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
1 Open Excel 2 For our tutorial, we will plot the data: After you complete this for the x-axis, repeat for the y-axis (click on any number
(b) A superimposed Microsoft Excel chart The red line is plotted according to the left and the blue according to the right y-axis -1
The default layout for a graph in Excel 97 (Figure 1) is typical of most graphing packages and the vertical axis as Y (dependent variable) Title 0 2
In this manual, we will use two examples: y = x, a linear graph; and y = x2, Excel recognizes the left hand column to be the x-axis values and the
Formatting Axes 1 6 3 Changing Data Markers 2 Graphing Multiple Data Series Make sure the x-axis data isn't put into the y-axis line by mistake
The dependent variable, in this case, the solubility, goes on the y-axis 2 The chart must be large to be read easily Select a scale that allows the
1 Create a graph using the new Excel 2013 version 2 Left click on the number scale beside the desired axis (X or Y) to choose which axis