Blog banner

How to combine two charts in Excel

Excel tips from our certified instructors

  • 20 February 2017
  • Author: Liam Phelan
  • Number of views: 392
  • 0 Comments

 

Advanced knowledge in Excel can be a great advantage in the market. Here in New Horizons our Microsoft certified instructors will keep you up to date with the best practices and new features of Excel. 

One great feature of Excel is Combo Charts, which will allow you to combine two different types of charts to contrast data sets. For example, you could combine column and line chart types, resulting in a much clearer graphic that has greater impact on your audience.

You can easily create a chart like this one, or convert an existing chart into a Combo Chart, by following the steps below:

To Create a Combo Chart

1 – Select the data you want to use in your chart

2 – Click on the Insert tab of the Ribbon, then click on Combo 

3 – Excel has now created a floating Combo Chart for you!

To Customize a Combo Chart

To customize a Combo Chart, follow these steps:

1 – Click anywhere in the chart that you want to customize.

2 – In the Chart Tools Design tab click the Change Chart Type button

3 – Choose Combo, in the Chart Type box, pick the type of Combo Chart you would like to use

4 – Under Choose the chart type and axis for your data series, check the Secondary Axis box for each data series you want to put on the secondary axis, and then change their chart type to Line.

5 - Make sure that all other data series are shown as Clustered Column.

To Convert an Existing Chart into a Combo Chart

1 – Click anywhere in the chart that you want to convert – the Chart Tools tabs will appear in the Ribbon

2 – In the Chart Tools Design tab click the Change Chart Type button

3 - On the All Charts tab, choose Combo, and then follow steps 6-8 above

Add Axis Titles to the Vertical Axes

To make clear what is appearing on each of the vertical axes, you can add axis titles.
Follow the steps below to do it:

1         Click anywhere in the chart, and then click the Chart Elements button  (top right of chart)

2         Check the Axis Titles box, click the arrow next to it, and then check the boxes of the axis titles you want to add.

3         In the chart, click each axis title one at a time, and then type a title that describes the data that is appearing on that axis.

 


Do you want to know more about the Excel?

You can watch our free webinar Getting Started with Microsoft Excel 2016 (Beginners)

We can also provide all the training that you need to take advantage of these features in your daily routine. Check out our next courses and dates available:


Click here to see all our excel courses


Contact us today to customise your training needs

 

Print
Tags: Excel
Rate this article:
5.0

Please login or register to post comments.

Name:
Email:
Subject:
Message:
x

Sign up for our Newsletter