How to create a combined chart – Column and Line on secondary axis
The combination chart category lets you build a chart that has columns on the primary axis and the line on a secondary axis which is great if the ranges are vastly different.
How to build
- Select cell range.
- Go to tab "Insert" on the ribbon.
- Press with left mouse button on "Insert Combo Chart" button.
- Press with left mouse button on "Clustered Column - Line on secondary axis" button.
- The chart appears.
- The x-axis values are missing, press with right mouse button on on chart.
- Press with mouse on "Select Data..." to open the "Select Data Source" dialog box.
- Press with left mouse button on "Edit" button.
- Select x-axis values and then press Enter.
- Press with left mouse button on OK button.
- Press with left mouse button on OK button.
Combination chart category
The Column and Line combo chart is a great choice if you want to differentiate two data series and make […]
Combine the stacked area chart and the clustered column chart if you want to differentiate at least two data series to […]
Excel categories
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.