Data Visualization with Excel – Part 1

There are abundant tool available for Data Analysis & Visualization but we all are using excel before we know what is data analytics & visualization.

Excel has been a great tool in analyzing the data, Presenting it in form of Graphs and for any simple or complex mathematical calculation with the data. So I thought why not explore the Analytical aspect of excel tool and showcase how it can be used an excellent tool in BI & Analytics domain. In my this post I would focus on Visualization of data in excel with different graph types:

Bar Chart:

Data to plot the Bar chart:

Fruits
No. of Consumers
Orange
29
Apple
19
Mix Fruit
41
Litchi
23
Pineapple
14
Go to Charts and select Column Charts Screen Shot 2017-05-15 at 20.37.43
Select the Data Range for Bar Chart:
Screen Shot 2017-05-15 at 20.38.30
Bar Chart is Generated for the above table data:
Screen Shot 2017-05-15 at 20.40.08

Multiple Bar Charts

Juice No. of Consumers
A B C
Orange 25 17 28
Apple 15 13 8
Mix Fruit 33 23 14
Litchi 18 22 14
Pineapple 9 5 6

Repeat the above same steps to create Multiple column bar chart:

Screen Shot 2017-05-15 at 20.49.42

Stacked Bar Chart

Repeat the same steps as above but select the chart type as Stacked Bar Chart

Screen Shot 2017-05-15 at 20.52.01

Percentage Stacked Column

This graph represents the percentage value for each of the items A,B,C for a specific fruit

Screen Shot 2017-05-15 at 20.54.30

Pie Chart

For Column A: Select Column Juice & Column A as data range and then select chart type as 3D Pie Chart

Screen Shot 2017-05-15 at 20.57.02.png

Histogram

Histogram is used to represent continuous frequency Distribution. There is no gap between the bars and it has a continuous appearance.

Select Column chart and Format Data Series to select Gap width as 0%

Screen Shot 2017-05-15 at 21.07.43

 

In Part 2(coming soon), We will learn how to plot the Histogram using Excel Data Analysis ToolPak and Polygons, Curves, Line Diagrams and also Series Data.