9. Two Charts in One
To understand your revenue, you need to examine the variables on which it depends. Combining two charts in one is a simple and effective way of doing this.
Why use two charts in one
- When charting company metrics, it's helpful to also show the variables on which this metric depends (e.g. revenue depends on volume and price)
- This allows the audience to gain greater insight into the cause of any change in revenue
Creating two charts in one
1 Create a bar-chart that shows both volume and revenue
2 Right-click on one of the volume bars and select Change series chart type
3 Select a line chart option
4 To give the line-chart it's own axis, select it and click on the Layout tab
5 Click the format selection option on the lefthand side and click secondary axis
6 Add y-axis labels using textboxes, placing them either below or above the axis
Most of the charts we create in this course focus on Company Revenue.
However, it’s also important to focus on the two variables that can change revenue, namely Volume and Price.
A great way to provide a visual comparison of Revenue with one of these two variables, is to use the Two Charts in One approach.
And in this lesson, we’re going to show a chart that combines Revenue and Volume that will look something like this.
Let’s start by creating a new slide, and we’ll insert a chart.
Let’s make it a Bar chart, click OK, and to speed things up, I’m going to add in the data off camera.
There we go. I’ll also reduce the enclosed area to just include The Year, the Revenue and the Volume.
With our data now entered, we can return to Power Point and begin formatting our chart.
As you can see, both Volume and Revenue are currently displayed as bars.
We’d like Volume to be displayed as a Line chart, so let’s select the Volume bars, right click and go to Change Series Chart Type.
We can then go to Line, and I’m going to select Line with Markers.
And when we return to our chart, we now have a Line chart and a Bar chart.
It still doesn’t look right however because they’re both based off the same axis.
Let’s give the Line graph its own axis by selecting it, then going to Layout, Format Selection, and then we’ll click Secondary Axis, Close and we now have the Line chart on a separate axis on the right hand side.
I’m going to make the line more prominent by giving it a bright red colour.
We’ll simply select the line, colour the markers red, and also colour the line red.
And I’m also going to thicken this line. So let’s right click on the line, go to Format Data Series, go to Line Style, and increase the width to three.
And that makes our line much more prominent in the chart.
I’d also like to widen the chart and give it as much horizontal space as possible, Let’s give it some more space by selecting the Chart Area and dragging this up so there’s no overlap.
Let’s now increase the width of the chart to take up the full area.
We can now move the Legend to the left so that it’s positioned nicely underneath the chart.
Moving the Legend in a PowerPoint chart can be tricky.
I find the easiest way to do it is to hold Shift when selecting the Legend, and then slide it either horizontally or vertically.
We also need to add labels to the axes, and we can do this using a Text Box.
Let’s select Text Box, let’s click on the chart and type our label.
Let’s then move it into position underneath our axes.
I’ll then duplicate this label and horizontally drag it to create Volume.
Let’s finish up by giving this chart a title. So we’ll create another Text Box, we’ll bold our text, and we’ll align it top left with our chart. Let’s Align Top and Align Left.
There’s a slight overlap with our chart so we can reduce its area, and to compensate for this, we may want to extend the length of the chart at the bottom.
So let’s select the area and drag it down, let’s drag the whole chart area down further as well.
This will require us to move our labels, so we can select them, and using the Arrow keys we can move them down the page.
And now our chart is pretty much complete.
As an exercise, try calculating the average price in each year for the Product, and in a new chart, compare it to Revenue as I have done with Volume.
I’ll include the answer in my finished version underneath this lesson.
Also, it might be worth trying to come up with some conclusions from the data, and including these as the titles to your slide.