Line charts are of the following types:
- Stacked Line charts
- 3-D Line charts
- 100% Stacked Line charts
A doughnut chart is called such because it looks like a doughnut. No jokes – it does. 🍩
Check it out here.
And a Pie chart looks just like a round pie with slices 🍕
Both these charts represent data in the form of slices. And so, they are used to show the proportion of different categories in the whole dataset.
Bigger the category, the bigger the slice, and vice versa.
This helps data visualization as you can take a look into the chart to readily tell which item makes the biggest (or the smallest) part of the dataset 🔎
How to make a pie chart/doughnut chart in Excel? Learn here.
A pie chart only suits a dataset with 7 categories (at most). If your data has too many categories to present, the doughnut/pie chart may become a mess with too many slices to it.
Such a tightly packed pie chart makes it hard to visualize the data ❌
A bubble is a chart with bubbles – yes, here’s what it looks like.
A bubble chart is an enhanced version of a scatter plot. Just like a scatter plot, all data points are presented as scatter points on the graph.
However, here’s the difference: a bubble chart has bubbles that are of variable sizes. The size of each bubble is proportionate to the size of the value it represents. So if your data has three columns (three sets to compare), a bubble chart is your best choice💭
You can make various types of bubble charts in Excel like simple and 3D bubble charts.
Adding chart elements (like data labels) to the bubbles can enhance the readability of your Bubble Chart.
Just like the name suggests, a stock chart shows fluctuations in data. The idea of a stock chart originates from the idea of a chart showing fluctuations in stock prices 🏪
However, by no means is a stock chart only limited to showing stock prices. You can use it to show any fluctuating data – could be annual performance scores, GDP, temperatures, or anything.
Here is what a stock chart looks like:
To make the perfect stock chart, arrange your data in the right order. There are different types of stock charts, like the ones listed below:
A Histogram makes a unique chart when it comes to data presentation. It displays data frequencies. Each column of the chart shows a bin (bin is a range, like 5 to 50) 🌂
You can change the size of the bins as desired. The length of each column shows the proportion of data relating to that bin (or range).
A Pareto chart is also a histogram, but with a line that shows the cumulative total percentage. See here:
Learn more about histogram charts in Excel here.
Sun Burst Chart
The sunburst chart is a hierarchal chart based on the idea of the sun with a broad radius of its rays 🌞
To make a sunburst chart, replace these rays with different hierarchies of the data that you want to be plotted.
If your data has different hierarchies, for example, if you want to show the sale of cars > ABC Brand & XYZ Brand > Sedan, hatchback, and SUV.
A sunburst chart will make one ring outside the chart for each of these hierarchies. The first hierarchy will make the innermost ring, and every next hierarchy will come next as another outer ring 💍
If you call this chart more of a set of hieratically arranged boxes – you are right.
A Treemap chart looks no different than that 💁♀️
It offers a helicopter view of a dataset with multiple categories. Each category has a different color that makes it easy to comprehend data.
Box & Whisker Charts
A box and a whisker chart in Excel looks like the one below:
It distributes data into different quartiles and shows together their mean and outliers. You’d see lines extending out of each box. What are those?
These lines are used to show the potential variability in data across their upper and lower quartiles 🚁
Learn more about Box & Whisker Plots in our blog here.
An area chart plots data by showing the area covered by it on the chart. See here.
Area charts are the best when it comes to comparing different streams of data together. Or when you want to show changes in data over a given period.
You can also plot the sum of your data on an Area chart to show much each category of the data contributes towards the whole 💪
Area charts can take different forms like the ones listed here:
- Stacked Area Chart
- 100% Stacked Area Chart
- 3-D Area Chart
Funnel charts are one of my top favorite charts in Excel. They are simple, easy to make, and represent the data in a fine, readable way 📖
You can use it to show values across multiple stages. For example, if you want to map the movement of a company’s revenue to its net profit, a funnel chart can help you with that.
It will show how much the revenue shrinks down after each expense. As the revenue keeps thinning down, the chart takes the shape of an inverted triangle (a funnel) 🔻
Here is what a funnel chart looks like:
When it comes to visuals, nothing beats the map chart. Needless to mention, a map chart looks like a map 🌐
It represents different categories of data and their sizes in the form of geographical regions on a map. It is best to use a map chart when you are showing geographical data that involves different regions, states, etc.
Each category in a map chart is shown using a different color that is defined through legends.