9. Two Charts in One

 
Subtitles Enabled

Sign up for a free trial to continue watching this lesson.

Free trial

Overview

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.

Lesson Notes

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

Transcript

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 are going to show a chart that combines revenue and volume that will look something like this.

Let's start by creating a new slide I'm going to 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 powerpoint and begin formatting our chart. As you can see, both volume and revenue are currently displayed as bars. We 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. Click ok.

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 are 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 access, close And we now have the line chart on a seperate axis on the right hand side. I am going to make the line more prominent by giving it a bright red color We simply select the line, color the markers red, and also color 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, and increase the width to three. And that makes our line much more prominent in the chart. I also would like to widen the chart and give as much horizontal space as possible. Let's give it some more space by selecting the chart area and dragging this up so there is 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 it's positioned nicely under 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 then slide it either horizontally or vertically.

We also need to add labels to the axis and we can do this using a text box. Let's select textbox, click on the chart, and type our label.

Then move it into position underneath our axis.

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 create another text box, we'll bold our text and we align it top left with our chart.

There is 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 full chart area down further as well.

This will require us to move our labels so we can select them and use 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 portion 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.