# 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**

**Select the Data Range for Bar Chart:**

**Bar Chart is Generated for the above table data:**

## 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:**

## Stacked Bar Chart

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

## Percentage Stacked Column

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

## Pie Chart

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

## 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%**

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.