How to create a combined Column and Line chart
The Column and Line combo chart is a great choice if you want to differentiate two data series and make the chart easier to read.
How to build
-
Select data.
- Go to tab "Insert" on the ribbon.
- Click the "Insert Combo chart" button.
-
Click "Clustered Column - Line"
Add values to the x-axis
- Right-click on chart
-
Click "Select Data..."
-
Click "Edit" button.
-
Select x-axis values.
- Click "OK" button.
- Click "OK" button.
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 [โฆ]
How to create a combined stacked area and a clustered column chart
Combine the stacked area chart and the clustered column chart if you want to differentiate at least two data series to [โฆ]
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.
English
Spanish
