CHARTS IN EXCEL
We make charts in excel to represent data graphically and to increase understandability of data.
Go to insert Tab->Charts->Recommended Chats
There are variety of inbuild charts, some of them are-
- Column
- Bar chart
- Line chart
- Area chart
- Pie chart
- Column chart
It represents vertical bars, contains two axis X-axis and Y-axis.
For example, we have two columns one is Years & other is Data. To make a chart
STEP 1: Select the data to form a chart
STEP 2: Go to charts->Recommended Charts->All charts->select column chart
Years |
Data |
Jan |
80 |
Feb |
63 |
March |
45 |
April |
95 |
May |
30 |
Jun |
79 |
July |
45 |
Aug |
89 |
Sept |
52 |
Oct |
71 |
Nov |
96 |
Dec |
42 |
- It will look, something like this.

OUTPUT

- Bar Chart
It represents horizontal bars.

- Line Chart
It is mainly used to represent Trends, when we want to compare trends in a company.

- Area Chart (Stacked)
It is similar to line chart only difference being it will cover the area.

- Pie Chart:
It is used to represent percentages.
