Geekers - Talking about diagrams cannot be separated from the representation of data in the form of two dimensions, namely tables. This diagram will later be used to translate data into three dimensions. To make this diagram, you can use programs related to data processing. One of them is a program provided by Microsoft, namely Microsoft Excel.
Microsoft Excel provides various types of charts, from column, bar, line, pie, area or radar. And each type consists of several different shape choices. You can choose a chart type that can be adjusted to your data needs. Then, how do you make a chart in Excel? Let's see an explanation of how to make a diagram in Excel below.
Also Read:
* 2 Ways to Make Upper & Lower Ranks in Microsoft Excel
* How to Use Freeze Panes in Microsoft Excel
* 2 Ways to Sort Data in Microsoft Excel
How to Make Diagrams in Excel
Well, this time I will explain how to make a diagram using Microsoft Excel 2013. Actually, the method for making a diagram in all versions of Excel is almost the same, the only difference is in the ribbon menu interface. Here are the steps.
First Step : Preparing Data
This is the first step before you create a chart in Excel. Unlike making diagrams in Word or PowerPoint, diagrams in Excel will be directly formed from data that has been made in tabular form. To make a table, please create data that is typed into a worksheet in Excel first. Then block the data to make it in table form.
how to make a chart in excel how to make a chart in excel
Step Two : Create a Diagram in Excel
1. After creating data in tabular form, block all cells that contain that data.
how to make a chart in excel how to make a chart in excel
2. Enter the Insert menu, select the type of diagram according to your needs. Here, I choose the type of column chart (Column Chart).
how to make a chart in excel how to make a chart in excel
3. The resulting diagram is in accordance with the data that has been entered. The following diagram is generated.
how to make a chart in excel 2016 how to make a chart in excel 2016
Step Three: Changing the View of the Diagram
Actually, until the second step, you have succeeded in making simple diagrams in Excel. However, you can change the default view of the chart. To make changes to the chart in the Design menu, see the following explanation.
A. Changing the Diagram Title
You can change the chart title by double-clicking on the Chart Title box.
how to make a chart in excel 2010 how to make a chart in excel 2010
B. Changing Chart Elements
On this Elements chart, you can show or hide the structure contained in the diagram. How to do it is easy. You just press the plus icon as shown below.
Changing Chart Elements Changing Chart Elements
C. Changing the Chart Style
If you want to change the display style of the chart, you can change it in the Chart Styles section.
Changing the Chart Style Change the Chart Style
D. Changing the Color of the Chart
You can change the color of the chart in the Change Colors section.
Changing Chart Colors Changing Chart Colors
That's the article about how to make a chart in Excel. Now, you can immediately try it in Microsoft Excel. We hope that this article will help you create eye-catching and attractive diagrams that suit your needs.