Visualization Examples in Excel (12 Suitable Examples)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as needed and make databases for the future. Moreover, one interesting thing is that we can create visualization examples easily in Excel. However, I have used Microsoft Office 365 for the purpose of demonstration, and you can use other versions according to your preferences. In this article, I will show you 12 suitable visualization examples in Excel. Hence, read through the article to learn more and save time.

Excel Visualization Tools: 12 Suitable Examples

In this tutorial, I will show you some visualization examples and the process becomes more interesting with Excel. In addition, the task is easy and simple. But you will need an arrangement in order to perform the operation properly. However, it includes several visualization charts which we regularly use in Excel. Here, I have used 12 different examples to make you understand the scenario properly. For the purpose of demonstration, I have used different sample datasets for each example and it will help you to identify the differences between the charts easily.

📌 Example 1: Column Chart

Usually, 2-D Column Charts are the most commonly used visualization examples in Excel charts. Moreover, it is easier to see the differences and relations with 2-D charts. Hence, follow the steps to easily create a Column Chart in Excel. For better understanding, I will follow the sample dataset showing how 3 people spend their time daily in Study, watching Television, using Mobile, and Sports. Hence, follow the steps below in order to create a column chart easily in Excel.

📌 Steps:

• First, select the entire dataset.
• Next, go to the Insert tab, and in the Charts area, select the Column Chart option.
• After that, select the first option in the 2-D Column.

• Finally, you will get a simple column chart like the below image. However, you can modify the chart according to your choice.

📌 Example 2: Bar Chart

In general, we use Bar Charts to perform certain business analytics in Excel. Moreover, it is easier to see the differences and relations with 2-D charts. Hence, follow the steps to easily create a bar chart in Excel. For the purpose of demonstration, I will follow the sample dataset showing how 3 people spend their time daily in Study, watching Television, using Mobile, and Sports. So, go through the steps below to complete the task.

📌 Steps:

• Firstly, select a cell from the dataset.
• Secondly, go to the Insert tab, and in the Charts area, select the Bar Chart option.
• Thirdly, select the first option in the 2-D Bar.

• Lastly, you will get a simple bar chart like the below image. However, you can modify the chart according to your choice.

📌 Example 3: Scatter Chart

Usually, Excel contains several types of scatter charts. However, I will draw a Scatter Chart for two variables. Hence, follow the below steps to create a Scatter Chart smoothly in Excel. For the purpose of demonstration, I have selected the following sample dataset. Here, a store owner wants to run a survey on your customers to find out whether those who come to the store from a farther distance shop more than those who come from nearby places. Here, one column indicates Distance, and the other one shows the Amount spent. Hence, follow the steps below.

📌 Steps:

• First, select any cell within the data.
• Then, click the Insert tab.
• Next, from the Charts group of commands, click on the Scatter (X, Y) command.
• Afterward, choose Scatter with Smooth Lines and Markers.

• Finally, you will get a scatter chart like the following image after some modifications.

📌 Example 4: Pie Chart

In general, a Pie Chart is made of slices that form a circularly shaped graph to represent numerical data of analysis and is one of the common visualization examples in Excel. However, pie charts are difficult to draw as they present the relative value of some particular data as a value or as a percentage in a circular graph. To explain this, I have taken the following dataset. Here, this dataset contains the Number of Students in 6 Months of a particular subject. Hence, I will make a pie chart using this dataset. Hence, follow the steps below to complete the operation.

📌 Steps:

• Firstly, select the data range with which you want to make the Pie Chart. Here, I have selected the cell range B4:C11.
• Secondly, go to the Insert tab.
• Thirdly, select Insert Pie or Doughnut Chart from the Charts group of commands.
• Fourthly, select the type of pie chart you want. Here, I have selected 2-D Pie.

• Finally, you will see that a pie chart with your selected data has been inserted into the Excel Sheet. However, you can modify the chart according to your personal preference.

📌 Example 5: Bubble Chart

Afterward, the Bubble Chart is a tool for three-dimensional data visualization. With the Bubble Chart, you may plot the third variable in addition to the standard two variables (x and y). Here, the first two variables are represented by coordinates, whereas the third is by the bubble’s size. For instance, I have a dataset of people with their Month in Column B, Product Price(X) in Column C, and Items Sold(Y) in Column D. Hence, read through the steps below in order to create the bubble chart.

📌 Steps:

• In the beginning, select the desired data table. Here, I have selected C4:D10.
• Then, click the Insert tab and go to the Scatter option.
• Next, select the Bubble chart option.

• In the end, you will get your desired chart. However, the chart will appear in the image below after some modifications.

📌 Example 6: Line Chart

Often, we need to create a Line Chart for certain business analytics, and the process becomes more interesting with Excel. However, the task is easy and simple and one of the common visualization examples in Excel. But you will need an arrangement in order to perform the operation properly. Hence, go through the following steps in order to draw an area chart using Excel. For the purpose of demonstration, I have selected the following sample dataset. Here, the dataset contains No. of Cars Sold per Month. Hence, go through the steps below to draw the line chart properly in Excel.

📌 Steps:

• Initially, select a cell in the dataset.
• Then, go to the Insert tab and move on to Charts.
• Next, select a 2-D Line Chart.

• Afterward, you will get your desired line chart. However, the chart will appear as the below image after some modifications.

📌 Example 7: Map Chart

Fortunately, Excel provides some very useful visualization tools. Among them, the geographic Map Chart is an interesting one. However, it is widely popular for visualizing datasets consisting of different areas. For the purpose of demonstration, I have selected the following sample dataset. Here, the dataset contains Nominal GDP per Capita for different States in the US. Hence, follow the steps below to create a map chart easily.

📌 Steps:

• First, select the entire dataset you want to make a map from.
• Now, go to the Insert tab in your ribbon.
• Then, from the Charts group, click on Maps.
• From the drop-down list, select the Filled Map.

• Consequently, a map chart will appear as in the image below after some modifications.

📌 Example 8: Radar Chart

Usually, a Radar Chart, also known as a “Spider chart” or “Polar chart” helps to compare the data of 3 or more than 3 variables correlative to a lead point. However, it is very effective at the time of a direct comparison of the variables and is great for visualizing data. For the purpose of demonstration, I have used the following sample dataset. Here, the table has Month, Shop 1, Shop 2, and Profit columns. Using this table, we will make a Radar chart in Excel. Hence, read through the steps mentioned below.

📌 Steps:

• First of all, select the entire data table.
• After that, go to the Insert tab.
• Next, from the Radar chart group, select Radar with Markers.

• At this point, you can see the Radar chart with markers. However, you can modify the chart according to your personal preference.

📌 Example 9: Treemap Chart

In general, the Treemap Chart in Excel is a common type of chart that provides a hierarchical representation of the data. Usually, this type of chart uses rectangular boxes, which serve as branches to represent data within groups. Moreover, this type of chart is very useful for comparing products and depicting the best-selling ones, and the relationship that exists between the data is actually a one-to-many relationship. However, I will show you how to create a Treemap Chart to show the sales value of various products in Excel. Moreover, the task is quite simple and easy. If you follow the below steps correctly, you will learn how to create a treemap chart showing values in Excel. So, without further delay, let’s see the process in detail.

📌 Steps:

• Initially, select the dataset.
• Then, go to the Insert tab and move to Insert Treemap Chart.
• Next, click on Treemap Chart.

• After that, you will get the Treemap Chart. However, you can make several modifications to the chart.

📌 Example 10: Sunburst Chart

In a nutshell, the Sunburst Chart in Excel is the dominant way of publicizing data charts with many details. It can show every portion of the data by using rings. In addition, a different portion of the rings represents different data values in the chart However, you want to create a Sunburst Chart for Employee percentages in Excel. Moreover, the task is quite simple and easy. If you follow the below steps correctly, you will learn how to create a sunburst chart in Excel. For the purpose of demonstration, I have selected the following sample dataset.

📌 Steps:

• Firstly, select the dataset.
• Secondly, go to the Insert tab and move to Insert Hierarchy Chart.
• Thirdly, click on the Sunburst Chart.

• Lastly, you will see that your sunburst chart has been inserted into your worksheet. However, the chart will appear as in the image mentioned below after some modifications.

📌 Example 11: Area Chart

Often, we need to create an Area Chart for certain business analytics, and the process becomes more interesting with Excel. However, the task is easy and simple and one of the common visualization examples in Excel. But you will need an arrangement in order to perform the operation properly. Hence, go through the following steps in order to draw an area chart using Excel. For the purpose of demonstration, I have selected the following sample dataset.

📌 Steps:

• Initially, select a cell in the dataset.
• Then, go to the Insert tab and move on to Charts.
• Next, select a 2-D Area Chart.

• Afterward, you will get your desired area chart. However, the chart will appear as the below image after some modifications.

📌 Example 12: Doughnut Chart

In general, Doughnut Charts represent the data in each cell as a slice of a doughnut. However, the chart may have one or more doughnuts stacked on top of each other. Additionally, doughnut charts allow you to display the relationship between different kinds of data, and each doughnut displays a set of data. In this example, I will show you how to make a doughnut chart in Excel with a single data series. Here, I have taken a dataset that contains sales information. However, the dataset contains the names of different Salesperson and Sales and I want to represent this data in a doughnut chart. Hence, go through the steps mentioned below in order to get your desired chart.

📌 Steps:

• First, select the dataset that you want to represent in your doughnut chart.
• Secondly, go to the Insert tab.
• Thirdly, from the Charts options, select Doughnut Chart.

• Lastly, you will see that your doughnut chart has been inserted into your worksheet. However, the chart will appear as in the image mentioned below after some modifications.

Download Practice Workbook

You can download the workbook used for the demonstration from the download link below.

Conclusion

These are all the steps you can follow to see some examples of visualization in Excel. Overall, in terms of working with time, we need this for various purposes. I have shown multiple methods with their respective examples, but there can be many other iterations depending on numerous situations. Hopefully, you can now easily create the needed adjustments. I sincerely hope you learned something and enjoyed this guide. Please let us know in the comments section below if you have any queries or recommendations.

<< Go Back to Data Visualisation in Excel | Learn Excel