How to make chart in excel?

Asked By 20 points N/A Posted on -

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?


Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 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.

Chart in Excel

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.

Pie chart in Excel

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

Pie Chart Diagram

Then the pie chart will be displayed as follows.

Design Tools

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


Answered By 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.

Login/Register to Answer

Related Questions