How To Make A Chart In Excel

How To Make A Chart In Excel

Microsoft Excel offers the option to make a chart easily. In this excel tutorial I will cover how to make a chart in excel which has many types of chart.

Whether you are a marketing staff, student or whoever you are need to create a chart, then, you could follow these step by step.

How To Make A Chart In Excel

We are going to build a chart base on this table below.

How To Make A Chart In Excel

Create Clustered Column Chart

In this excel tutorial, we are going to Create Clustered Column Chart as an example. This is a simple chart. So this is perfect for a beginner.

1. Move your cursor over the table you just created to highlight it.

2. Convert this into a chart by clicking on the following: Insert, Recommended Chart and Clustered Column.

How To Make A Chart In Excel

How To Make A Chart In Excel

3. To change the title, click on "Chart Title". Type the new title.

How To Make A Chart In Excel

4. Create Axis Title. To do this, click on "plus icon" and check the Axis Title.

How To Make A Chart In Excel

How To Make A Chart In Excel

5. Create Data Labels. To do this, click on "plus icon" and check the Data Labels.

How To Make A Chart In Excel

6. Show Data Table. To do this, click on "plus icon" and check the Data Table.

How To Make A Chart In Excel

7. Add Trendline. The option trendline has some styles, they are Linear, Exponential, Linear Forecast, etc. To do this, click on "plus icon" and check the Trendline.

How To Make A Chart In Excel

You can change the Trendline style, by clicking on trendline you have just created.

How To Make A Chart In Excel

Change The Style Of The Chart

1. Click on Chart Style. You can find this option on the upper-right-corner of the chart you have just created.

2. Click on style.

How To Make A Chart In Excel

3. Here is the new style of the chart.

How To Make A Chart In Excel

Change The Color Of The Chart

1. Click on Chart Style. You can find this option on the upper-right-corner of the chart you have just created.

2. Click on color.

How To Make A Chart In Excel

3. Choose the color you like.

Filter The Content Of The Table

You can filter the content of the table. For this example, we are going to do filter the salesman. We are going to show what Jhon (Salesman) has contributed to the total sales.

1. Click on Chart Filter.

2. Check "Jhon" and uncheck another salesman.

3. Click apply.

How To Make A Chart In Excel

PivotChart And PivotTable

You can create a pivot chart based on a table with ease. To do these, follow these steps.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on pivotchart

4. Again, click on pivotchart

5. Here is the result.

How To Make A Chart In Excel

I have tutorial in detail how to create a pivot chart and pivot table. You may click on that link.

Insert Column Or Bar Chart

This step by step guide you to make a bar chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Column Or Bar Chart"

4. Click on clustered column. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Waterfall, Funnel, Stock, Surface or Radar Chart

This step by step guide you to make a high low close chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Waterfall, Funnel, Stock, Surface or Radar Chart"

4. Click on high low close. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Line Or Area Chart

This step by step guide you to make a line chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Line Or Area Chart"

4. Click on line chart. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Statistic Chart

This step by step guide you to make a statistic chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Statistic Chart"

4. Click on histogram. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Combo Chart

This step by step guide you to make a combo chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Combo Chart"

4. Click on clustered column-line. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Pie Or Doughnut Chart

This step by step guide you to make a pie chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Pie Or Doughnut Chart"

4. Click on pie chart. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

Insert Scatter (X,Y) Or Bubble Chart

This step by step guide you to make a scatter chart.

1. Move your cursor over the table you just created to highlight it.

2. Click on insert

3. Click on "Insert Scatter (X,Y) Or Bubble Chart"

4. Click on scatter chart. This is one of many style of chart. You can choose another style of chart.

5. Here is the result.

How To Make A Chart In Excel

The admin

The Admin

I am the admin of thewebsitehub.org.

Share This Post

Your Comment