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

1. 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

• It will look, something like this.

OUTPUT

2. Bar Chart

It represents horizontal bars.

3. Line Chart

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

4. Area Chart (Stacked)

It is similar to line chart only difference being it will cover the area.

5. Pie Chart:

It is used to represent percentages.