Excel Line Column Chart 2 AxesIf you use two different chart types in a single chart, it's called a combination chart, like the line-column chart shown below. This example is on 2 axes, and the steps are shown below Author: Debra Dalgleish |
Set Up the Source DataFirst, set up your data for the chart, on an Excel worksheet. In the example shown below, the product name, number of cases sold, and sales amount are in adjacent columns
At the bottom of the list, in cells B9:D9, the total amounts are calculated, using the SUM function.
There is a worksheet heading in cell B2 - Product Sales. |
Video Transcript: Create Line Column ChartHere is the transcript for the video shown above. Create a Line Column ChartIntroductionIn Excel 2003, and earlier versions, when you inserted a chart, the chart wizard You could see standard chart types, and there were also custom types, and some of these were combinations, like a Column - Area or Line - Column or Line - Column on 2 Axes In newer versions of Excel, these combinations aren't available when you create a chart, but Create a Column ChartHere is the same data, in Excel 2010, and I'll insert a chart. On the Ribbon, go to Insert, and I'll start with a Column chart and I'll use a 2-D column. And here we can see cases and amount. The cases are a much lower number than the amount, so we can barely see them here. Change Chart Series to LineBut with the chart selected, I can go to the Layout tab, and select cases. Now all those columns are selected, even though we can barely see them. I will right click on one of those, and click Change Series Chart Type. And now, I can, instead of having that as column, I'll change that to a line You can select any one of these lines. I'll select the first one, without markers. Click OK. And now we can see that we do have columns and line together, in a single chart. Put Line on Secondary AxisOne of the old combination chart types was a Line-Column on 2 Axes, and that would be useful in this situation, where we can barely see one of the series. So again, I will select cases series, and format the selection. Right now it's on the primary axis, and I'll put it on the secondary axis. And click Close. Now we can see the cases much more clearly. They're plotted on this secondary axis, which goes from 0 to 250, and the amounts are still on the primary axis, which goes from 0 to 18,000 So in newer versions of Excel, you can create your own combination charts, by right-clicking on a series, and changing its chart type. |
Get the Sample FileClick here to get a zipped sample file for this tutorial. The Excel file is in xlsx format, and does not contain any macros. |
Related Links |
Last updated: December 26, 2022 8:01 PM