11. Growth Rates and Baselines on Charts
Learn how include additional information on your chart with objects such as growth rate arrows and baselines.
Adding baselines to charts
- Option 1: Simply draw a line over the chart where you think the line resides
- Option 2: Create two new columns in the chart and convert these to lines
Adding growth rates to charts
1 Calculate the growth rates for each year
2 Draw an arrow and an ellipse shape which contains the growth rate
3 Align the two objects middle and center before positioning above the two columns
4 Repeat for the remaining years in your chart
5 Group each growth rate object and distribute them horizontally for neat formatting
We’d often like to add some additional features to our charts, such as Growth Rates and Base Lines. But unfortunately, PowerPoint doesn’t make this an easy task. Unless you have a PowerPoint plug in like Think Cell, you’ll have to use some manual tricks to add these features, which we’ll be doing in this lesson.
Let’s start with Base Lines.
In this chart I’d like to add two lines that show the highest and lowest annual revenues for the ten years prior to 2007.
A simple horizontal line with a label would work well here.
The first option is simply to draw a line on top of the chart.
I’ll start by duplicating this chart, and then I’ll duplicate this line with Ctrl + Shift and hold the mouse button and drag it onto the chart.
And I’ll do it one more time for the Low Revenue mark.
The Low Revenue figure is $47 million, so selecting the Line and holding Shift, I can then move it to where I think $47 million might be.
That looks about right. The High Revenue figure is $98 million, and this line looks roughly in the right position.
I can now format these lines and add a label.
So I’ll select both of them by holding the Shift button, and I’ll thicken them and give them dashes.
I’ll color the High Line green, and the Low Line red, and off camera I’ll also add labels.
This method of adding lines to charts comes with some obvious drawbacks.
The first is that the lines are not in exactly the correct position.
And the second drawback is if I resize the chart, the line positions have to be updated as well.
However, this method does offer a handy quick fix for adding lines to charts, and it allows you to apply nice labels.
If you want a more exact solution, you could actually draw lines within the chart.
I’ll show you how to do this by again duplicating the first slide, and this time we’ll right click on the chart and go to Edit Data.
And we’ll create two new columns.
The first column will only include the values for the Low Revenue, which is 47.
We’ll copy this for the remaining cells.
And the second column will just contain the values for the High Revenue, which is 98.
We can now return to our PowerPoint slide and convert these bars into lines.
So we’ll right click on the first Bar and change Series Chart Type, we select Line and press OK.
We’ll then click on the second Bar, right click again, change Series Chart Type, and select Line again.
And we now have exact Lines representing 47 and 98 on our chart.
What’s more, if we change the size of the chart, the Line positions change accordingly. We can format these Lines by selecting them, changing the color and adding dashes.
And I’ll do the same for the Lower Line, so that it looks similar to the Lines in the previous slide.
The one drawback with this method is that it’s a little harder to add nice labels for your lines.
One solution you might consider consider is adding a Legend to the chart.
Let’s now move on to our last topic in this lesson, which are Growth Rates. So again I’ll go to the first slide, right click and duplicate.
And my first task will be to calculate the Growth Rates, and we’ll do this in the Excel sheet.
So when we go to Edit Data, we can calculate the Growth Rates in here.
And the Growth Rate formula is simply the New Revenue minus the Old Revenue divided by the Old Revenue.
And then we can convert that into percentages with this Icon.
I can then copy and paste this for the remaining years.
Knowing the Growth Rates, I can now return to my PowerPoint slide and add them to my chart.
For Growth Rates I like to combine an Arrow with an Ellipse.
So I’ll first select the Ellipse in the Drawing tab of the ribbon, and then draw the Ellipse and add in my Growth Rate, which for the first year is %30.
I might need to extend the Ellipse so that the text fits neatly.
I’ll then put an Arrow behind this Ellipse.
I’ll move the Ellipse to the front, and I’ll thicken the Arrow and change the color.
That looks much better. And now I’ll select both objects, group them and place them above the right years.
I can add Growth Rates for the rest of the years in a similar way.