Looking Good Excel Line Chart Two Y Axis
Click Line with Markers.
Excel line chart two y axis. Change other parameters for the secondary axis. When the Format Data Series window appears select the Secondary Axis radio button. How to add next data series with another axis see Combining several charts into one chart.
They are sitting on top of one another to give the appearance of a single line. Set your spreadsheet up so that Row 1 is your X axis and Rows 2 and 3 are your two Y axes. Set Up the Source Data.
Click the Insert tab. Changing the Display of Axes in Excel Every new chart in Excel comes with two default axes. Excel 2013 and Excel 2016.
In the Charts group click the Recommended Charts option. See how to add the secondary horizontal axis and display both horizontal axes on the same side for more details. Fill in entries for series name and Y values and the chart shows two series.
Select the data range and insert a chart first by clicking Insert and selecting a chart you need in the Chart. There are instances when there are data series plotted on both the primary and secondary axes. This section will outline how to make a graph with two Y-axis in Excel using the ChartExpo add-in.
Red yellow and green. However we still need to set up a secondary Y-axis as Series 2 is currently using the primary Y-axis to display its data. This is easy to fix.