I think you will find that creating combo charts and modifying them to get to your final polished output is much easier is a leading presentation/slideshow sharing website. Set the Category to Currency and the Decimal Places to zero. Right click on the secondary axis (Total Transactions) and choose Format Axis.ģ. Edit the axis title text Format total transactions axis as $ġ. Click the Add Chart Elements button next to the chart.ģ. So the two steps left are to add axis titles and format the Total Transactions axis as $.

Chart title is already added to the chart and all you need to do is edit the text.

There are a couple steps in the previous post that are no longer necessary since they are the new defaults for 2013: Now we can walk through the finishing touches to make your combo chart look more professional. Check the Secondary Axis box for the Total Transactions and click OK.Īs you can see it now takes four steps to create a simple combination chart instead of the eleven steps outlined in the earlier post! Finishing touches Given that units sold and total transactions have different scales we need to move one of them to a secondary axis so we can clearly see the values for both.Ĥ. You can then use the table below the chart to change each series to a particular chart type and move series to the secondary axis. This combo chart will split the series 50/50 between a clustered column and a line chart. Click the All Charts tab and select the Combo category.Īt the top of the dialog you will see a couple pre-canned combo charts to get you started and Clustered Column – Line is the default.

Go to the Insert tab and click Recommended Charts.ģ.

Select the data you would like to use for your chart.Ģ. To follow along, use this sample workbook.ġ. I would like to create a single chart like the one below so I can see both data sets in one view.Ĭombining different chart types and adding a secondary axis 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.

Compare two columns in powerpoint