Change the chart type of one or more data series in your chart (graph) and add a secondary vertical (value) axis in the combo chart.
Create a combo chart with a secondary axis
In Excel 2013, you can quickly show a chart, like the one above, by changing your chart to a combo chart.
-
Click anywhere in the chart you want to change to a combo chart to show the CHART TOOLS.
-
Click DESIGN > Change Chart Type.
-
On the All Charts tab, choose Combo, and then pick the Clustered Column - Line on Secondary Axis chart.
-
Under Choose the chart type and axis for your data series , check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.
-
Make sure that all other data series are shown as Clustered Column.
Want more?
You can emphasize different types of data, such as Temperature and Precipitation, by combining two or more chart types in one Combo chart.
Different types of data, often, have different value ranges and with a Combo chart, you can include a secondary axis.
Select the cells you want to chart.
Combo chart is not a Quick Analysis option, so we click the INSERT tab on the ribbon, click the Combo button, and choose an option.
I am moving and resizing the chart to make it easier to work with.
I give the chart a title.
Adding a secondary axis for Precipitation will make the chart easier to understand.
I double-click the Precipitation line in the chart and select Secondary Axis in the task pane.
It would make the chart even clearer, if we added axis titles.
Click the CHART ELEMENTS button, click the arrow beside Axis Titles, select Primary Vertical and Secondary Vertical, click the title boxes and type the appropriate text.
Up next, Copy a chart.
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
