How to Make a Diagram - Data presentation is needed on several occasions and one of the mandatory components in a presentation is a diagram. This diagram is one of the easiest tools to translate data in three-dimensional form.
There are several applications that can be used to process data, including making these diagrams and one of the most commonly used is Microsoft Excel.
Maybe you are not familiar with this one computer program? Yuph, Microsoft Excel offers convenience in processing data. Likewise when you want to make a diagram. There are quite a number of diagram options that you can choose to translate the data so that it is easy to understand.
The many choices of diagrams / charts will also make it easier for you to adapt them to your needs.
Types of Diagrams
Before explaining further how to make diagrams in Excel, you also need to know the types of diagrams available in Excel. The types of diagrams / charts that you can choose include: Column, Line, Pie, Bar, Area, Scatter (X Y), Stock, Surface, Donut, Bubble, and finally Radar. For more details, see the following reviews:
1. Column Charts
This chart is the type that Excel users usually choose, given its generic and easy-to-understand shape. This chart is perfect for translating data changes over time. Can also be used to provide a visualization of the comparison between one item and another.
2. Line Charts
This diagram can also be used to translate data that is continuous or continuous in a certain period. If you want to use a chart to represent a trend over time, then this type of diagram is perfect. For example: the development of the Covid-19 outbreak from day to day in Indonesia, you can use this diagram.
3. Pie Charts
This pie chart is also appropriate to use to provide data visualization / size of a data series, which is presented proportionally from the overall data presented. Generally, each data item is also presented as a percentage.
4. Bar Charts
This diagram has almost the same function as a column diagram which is also used to provide visualization of comparative data between items.
5. Field Charts (Area Charts)
This type of chart is also recommended for translating changes over time.
6. Spread Charts (XY Scatter Charts)
This chart is recommended for translating the relationships between numeric values across multiple data sets.
7. Stock charts
Maybe you can already guess what this type of diagram is for. Yuph, this diagram is recommended to show fluctuations in stock or stock prices. But not only that, this diagram can also be used to provide visualizations of other scientific data, for example you can use this diagram to show changes in temperature fluctuation or something else.
8. Surface Charts
This diagram is recommended when you want to visualize a combination of two or more data. This type of chart can be used to show areas or regions that are still within the same range of values. For example, it can be used to view data on the development of covid-19 between districts in Central Java.
9. Donut Charts
Functionally, this diagram has almost the same use as pie charts. This diagram provides a visualization of one item with the entire data, it can also be used to describe more than one data series.
10.Bubble Charts
This diagram is suitable for drawing two data variables represented by the x value (horizontal) and the y value (vertical).
11. Radar Charts
This chart is recommended for comparing data from the entire data set.
You can choose the eleven diagrams above when you want to process and translate data into diagrams or graphs. By knowing the types of diagrams above, it is hoped that you will easily choose which one suits your needs.
Next, let's look at how to make a chart in Excel as follows:
How to Make Charts in Excel for Beginners
After you are familiar with the types of diagrams above, then we will further explain how to make diagrams in Excel. You can use any version of Microsotf Excel because they are basically the same. The only difference is the interface menu.
Here are the steps for making diagrams in Excel that you can practice:
1. Prepare the Data
visualized in the form of a graph or diagram. In the Excel program, usually the data will be in table form.
If you don't have data in table form, then you can enter the data into an Excel table first. after that, the new block table will be translated into diagrams.
2. Start Creating an Excel Chart
After you block the data table, select the insert menu and choose the type of diagram that suits your needs. if you are still confused, you can read the explanation of the types of diagrams above again.
After you select it, then on your computer screen, the diagram you choose will appear. Until this stage, the diagram has been visualized, it just needs to be further arranged.
3. Change the Display Diagram
The diagram has actually been formed, it just needs to be further regulated. Until this second stage, the default graphic display already exists, but it needs to be changed its appearance to fit the data you want to visualize.
To change it:
- Select the Design menu
- If you want to change the title, then just click Chart Title
- To change the structure of the diagram whether you want to show or want to hide it, just select Chart Elements
- To change the chart style, you can select Chart Styles
- Meanwhile, if you want to change the chart color, you can click Change Colors.
How? Easy enough to put into practice right? Actually, how to make diagrams in Excel is simple and not complicated. It's just that accuracy and understanding are needed regarding the function of each type of diagram. Thus, the use of this diagram can be in accordance with its designation, not just choosing the diagram. By choosing the right diagram, of course the data represented will also be easily understood by many people.
Those are the easy steps on how to make diagrams in Excel that you should know. With just 3 steps, you can create a diagram that suits your needs. the above steps, using Ms Excel 2013 sample, but can be tested in various versions of Microsoft, only different versions of the interface might be different. Hopefully helpful and useful.
Posting Komentar
Posting Komentar