To make the chart easier to read, the Total Transactions should be converted to a secondary axis, thus allowing for the data sets to be scaled differently. While quite cool, our chart is still difficult to analyze because the scale of the Total Transactions is much larger than the scale of the Units Sold, and so we can’t gain much insight from the virtually indistinguishable columns. In fact, you can combine far more than two chart types by repeating the above process with additional data sets, and selecting a different type from the Change Chart Type dialog box. Voila, you’ve created a chart with two chart types (column and line)!Ĭhart plotting two data sets with bar and line chart. In the Change Chart Type dialog box, select the Combo, change Total Transactions to Line and click OK. Once you have selected the Total Transactions column in the chart, click Chart Design, and then click the Change Chart button.ģ. You should now see the data set highlighted:Ģ. Rather, click one of the orange bars in the chart. Don’t click the legend text Total Transactions. Click the Total Transactions data column in the chart.
The next big step is to change the chart type for the Total Transactions data set into a line chart.ġ. Now we have a column chart with two data sets ( Units Sold and Total Transactions), both charted using the same chart type.Ĭhanging one of the data sets to a line chart For the sake of this scenario, select one of the 2-D column types. Go to the Insert tab, and then choose a type of column to insert (as shown below).Select the data that you would like to use for your chart.( Note: It actually doesn’t matter which chart type you start with, but if you’re working with a multiple data sets, I’d pick the chart type which applies to the majority of your data – it’ll mean less work for you later). For this scenario, I want a chart with columns and lines, but I’ll start with a regular column chart. The first step in building a chart with more than one chart type is to actually set up a chart with just a single chart type. Sample data showing units sold and total transactions. To ensure you can follow along, we’ve created a simple data set below:
#Combine bar and line graph excel how to#
Then we’ll show you how to add some finishing touches to make your chart look polished and professional. We’ll walk you through the two major steps- combining different chart types and adding a secondary axis. I’d much rather create a single chart that incorporates both data sets such as the one shown below.Ĭhart showing both units sold and total transactions.ĭaunting though it may seem, it turns out that making this kind of chart isn’t very difficult at all.
However, it will be challenging to analyze and compare the two charts separately. I could make two different charts-one plotting units sold per month, and another plotting total transaction revenue by month. I’m hoping to identify trouble spots, such as high unit sales that result in low revenue, which may in turn indicate that the units are being sold too cheaply. Suppose I work at a manufacturing company, and I’d like to analyze the number of units we’ve sold over the last few months and the total revenue generated.
0 kommentar(er)
