How to make chart in excel?

Asked By Abelina Sophia 20 points N/A Posted on - 07/29/2012

I have heard that charts are able to create in Microsoft excel easily. I tried to make a chart.

However, it was not successful. Can anyone explain me to make a chart with an example?

Thanks.

• Status: Open
• Question Views: 1148
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #134506

How to make chart in excel?

I will explain you how to make a chart in Microsoft excel. I will take following data as an example in order to explain the answer. Look at this image.

First select the entire set of data including headings except total.

Then click on the insert tab. Now you can see there are many types of chart available in the chart section.

Please select a type as you want. I will select pie chart type.

Then select 2D- pie or 3D- pie chart as you wish. I will select 3D – Pie category and click on that.

Then the pie chart will be displayed as follows.

As such you can create any types of chart in Microsoft excel.

Thanks.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 07/29/2012
• Question Category: MS Excel

Answered By Anthew Staw 0 points N/A #134507

How to make chart in excel?

It actually depends on what chart you want. There are actually a lot of charts to choose from like column, line, pie, bar, area, scatter and other charts. To make a chart, here’s what you should do.

1. Make a table which contains data. It should have headings.

Heading 1           Heading 2            Heading 3

Data1                     Data2                   Data3

Data4                     Data5                   Data6

2. Then highlight the entire table that you made.

3. Click on the Insert tab. Then click on Charts.

4. Setup the chart so that the data that appears on the chart are the ones you need.

5. Then follow the directions and you’re done.

Hope this helps.

About Anthew Staw

Questions
3

Answers
34

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/03/2012
• Question Category: MS Excel