For this lesson you need to open the sample file: Hawaii Climate-1 from your Sample Files folder.
Excel allows you to allocate a different chart type to each data series. This opens up many interesting possibilities.
In this lesson we'll chart the Hawaii climate as a combination Clustered Column/Area Chart, with Clustered Columns for the High/Low temperature and an Area Chart for Rainfall.
To do that I'll click in any cell within the range. Because we want to chart the entire data range there's no need to select the range of cells.
I'll now click Insert, then in the Charts group: Insert Combo Chart. And you can see that there's a gallery showing three suggested Combo Charts for the range. As it's a gallery, I can hover over each to preview the suggestions.
Here's the first, and that doesn't work very well for me.
Here's the second, once again I don't like that.
And here's the third, and that doesn't seem to work at all.
So I'm going to have to create a Custom Combo Chart. So I click the Create Custom Combo Chart button. And you can see that, at the moment, the Average High and Average Low temperatures are being charted as Clustered Column chart types. And I think that works very well.
But for the average rainfall I'd like to plot an Area chart type. So I'll click the chart type dropdown, to the right of Average Rainfall, and then I'll click the Area chart type.
I can see from the preview that that seems close to what I want. So I'll click the OK button and I can now see a Clustered Column chart type showing Average High and Average Low temperatures, and a gray Area chart showing the average rainfall.
Well the chart isn't bad but it could be improved. Because there's only one Vertical Axis, the Rainfall's Area chart type dominates the chart. Adding a second Vertical Axis will solve this problem.
Now you could do this using the skills you learned in Lesson 5-23, but instead I'm going to use a different technique by recalling the Insert Chart dialog. So I'll right click anywhere in the chart and then select Change Chart Type from the Shortcut Menu and the previous dialog reappears. Except this time it's titled: Change Chart Type, (instead of Insert Chart Type).
To the right of each chart type, you can see that there's a Secondary Axis checkbox. Well I'd like a new Vertical Axis for the Average Rainfall in Millimeters. So I'll click the checkbox to the right of the Area chart type and then click the OK button.
And you can see that the chart now looks a lot better with two axes: one for Temperature and one for Rainfall. But it could be confusing which Axis is which, and the units that each Axis relates to. So let's add some Axis Title elements and give them meaningful names. You learned how to do this in Lesson 5-9 and in Lesson 5-5.
So I'll click just inside the border of the chart to activate it, then I'll click the Chart Elements button and I'll click the Axis Titles elements checkbox.
I now have Axis Titles for the X Axis and both of my vertical axes.
Well the X Axis is clearly showing months,so I'll click on Axis Title and I'll type: Month.
The left hand Vertical Axis is showing the temperature in degrees centigrade. So I'll click on the left hand Axis Title and type: Temperature C.
The right hand title is showing Rainfall in Millimeters. So I'll click on the right hand Axis Title and type: Rainfall mm.
And I'll also give the chart a title. So I'll click the Chart Title element and type: Hawaii Climate.
The chart now looks very professional and it's doing a great job of visually depicting the average high and average low temperatures, along with the rainfall for each month in Hawaii.
All that remains for this lesson is to save your work. And I'm going to save with the new name: Hawaii Climate-2. And as usual I'll save to the folder above my Sample Files Folder.
I click the Save button and you've now completed: Lesson 5-24 Create a Combination Chart Containing Different Chart Types.