Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Charts are one of the most important parts of Microsoft Excel. It helps us to present our data in an understandable manner.
In Excel, we have different kind of charts to present our data in different ways. Even there are lot of advanced charts which we can create in Excel by making small amendments in default charts.
The bad news is, most of the Excel users don’t explore charting techniques much. But, the good news is you can learn to create all those charts with little extra efforts.
The top most benefit of using advanced charts in Excel is they are focused on a specific kind of data and make it more understandable.
So today, in this post, I’d like to share with you 10 most useful advanced Excel charts which can help you to become a charting Expert.
Without further ado, here are the 10 charts that will help you to become a charting sensation in your office.
A step chart is an extended version of a line chart. It’s is perfect to use when you want to show the changes happened on irregular intervals.
Unlike line chart, it doesn’t connect data points using a short distance line. In fact, it uses vertical and horizontal lines to connect the data points.
Milestone chart also knows as timeline chart. It’s one of the favorite charts of project managers and help them to track their project’s progress in a simple way.
It’s just like a time in which each stage of the project is captured with the date of completion.
Milestones are tools used in project management to mark specific points along a project timeline. These points may signal anchors such as a project start and end date, a need for external review or input and budget checks, among others.
A waffle chart is more likely a square pie chart. It’s a bunch of 100 small squares where one square represents the 1% of the total value.
I’m sure you have seen it in dashboards and news article graphics. And, to create it we need to use conditional formatting.
When it comes to showing the comparison of different things with each other tornado chart can be useful for you.
It looks line a real tornado where large items are on the top and lowest at the bottom. And, each item has an opposite item for comparison.
Gantt chart is one the most useful chart for project managers. It can help us to track project’s progress. Unlike a milestone chart, a Gantt chart can track completion days, delayed days, days pending, totals days, etc.
In short, it’s complete chart to track your projects with all the important details which everyone requires.
A bullet chart is just like a column chart but instead of multiple columns here we have only one. It can help us to track a single point target vs. achievement.
There are three major components of a bullet chart:
A thermometer chart is another useful chart to track a single point target vs. achievement and can help us to present our data in an understandable way.
It looks like a thermometer where entire chart presents the target and filled part is the achievement. The filled part goes up as the achievement increase.
If you are not happy to use bullet chart or thermometer chart then you can use a gauge chart. A gauge chart is also known as a speed-o-meter chart.
A population chart is a two-sided bar chart which helps us to compare the population of different age groups of genders.
A population pyramid, also called an age pyramid or age picture diagram, is a graphical illustration that shows the distribution of various age groups in a population (a country or region of the world), which forms the shape of a pyramid when the population is growing.
A pictograph is not a separate kind of chart.
By creating a pictograph we can use an image in a chart to make it more presentable. just like we have use an image in the below chart to present the number of employees in a compny in different age groups.
Advanced charting techniques are one of those things which differentiate Experts from novice Excel users.
As I said by using advanced Excel charts make your data more focused and easily understandable. You can also use them in your dashboards and template to make them more effective.
I hope, the list of charts which I have shared with you will help you to get better at charting.
Now tell me one thing. Do you have any other chart which you use frequently in your work? Please share with me in the comment section, I’d love to hear from you.
And, please don’t forget to share this list with your friends. I’m sure they will appreciate it.