Here are some useful ideas for combination Data-Driven charts in PowerPoint. Discover ways to add more insights to your charts and make your message memorable.
Quick Word About A Combination Chart:
As the name suggests, these are created by combining two or more chart types in a single graph. They help your audience get more information from your charts and make your message more memorable. In this article, we will see some examples of such charts and their application in business presentations.
All the data driven chart templates you see in this article are taken from our ‘Visual PowerPoint Graphs Pack’. The pack has more than 320 business relevant graph templates that are super easy to use. You just need to replace sample data with your own data in the accompanying worksheet.
The preformatted charts update themselves automatically. It is a useful resource for any business presenter who wants elegantly designed charts without wasting a lot of time constructing them from the scratch.
You can find more details at the end of this article.
Below are 5 Ideas for Creative Combined Charts…
1. Adding clarity by combining chart types:
One of the basic uses of a combination chart is to bring more clarity to base chart type. For example, take a look at the following area chart:
It is not easy to read the values of data points by referring to Y-axis each time. If you add data labels you get a messy result as follows:
However, when you combine area chart with a simple line chart, you get a clear picture. In the combination area and line chart below, the white drop lines make it even easier to read the data.
2.Adding context to performance
Here is a variation of the above chart. In this, we show target for each month to give context to performance values:
It is easy to know the months where we exceeded target and the months where we have fallen short.
Related: Trend Line Chart Ideas
3. Adding second level insights
Sometimes combination charts are used to add second level details to base data. Take a look at the following performance chart:
We added a secondary axis to plot cumulative performance values along with the base performance values. The chart not only helps you see performance values for individual months, but also helps you see the trend in growth.
Related: Performance Report Ideas
4. Showing Control Range
It is possible to ad a control range to see if the performance values are within bounds. We combined line chart with stacked column chart to create the following control chart:
5.Mark significant events
You can use combination chart to mark significant events along a timeline. For example, take a look at the following chart:
Source: Before After Event Chart from Visual Graphs Pack
We combined two column chart types to create the above chart. Here, the audience can see the performance before and after a significant event.
The kind of results you can achieve by combining chart types is limited only by your imagination.
More inspiration for business presenters:
While creating basic charts is easy, it takes a lot of time and effort to create more complex charts. When you want to combine chart types, you need to have a clear understanding of the capabilities of Excel function embedded in PowerPoint.
If you are too busy to invest time in exploring all the capabilities of the software, we have an elegant solution for you. We recommend you take a look at our ‘Visual PowerPoint graphs pack’.
In the time you take to create a boring data table, you can create an insightful chart. For example, take a look the following template:
To edit the chart, right click on the chart and go to ‘Edit data’. A worksheet opens up. Replace yellow cells with your own data. The chart automatically updates the values.
You don’t even have to type in the data. You can copy data from your excel sheet to replace values. You can’t find any easier way to create insightful charts for your business presentations.
So, why waste time creating your charts from the scratch, when you have such a high quality solution available off the shelf?
You can find more such insightful articles that provide creative ideas. Do browse through Presentation Process for more.