4+ How to Create Graphs in Microsoft Excel (Complete+Pictures)
A graph is a visual form of a table, where the table contains text or numbers that can be presented in the form of images.
Graphs are usually used to quickly display quantitative information in the form of images that refer to the comparison or development of an object or event. In other words, graphs make reading data easier than using tables.
Graphing can be done on some Microsoft, such as Microsoft Word, Microsoft Power Point or Microsoft Excel. This time, I will give a tutorial on how to make graphics on Microsoft Excel. The following is a complete explanation of how to create charts in Excel.
How to Create Graphs in Microsoft Excel
A. Opening Microsoft Excel
1. First of all, you have to open Microsoft Excel by clicking the icon as below.
2. Then, click blank document. Here, you will create new data.
B. Enter Data
3. Enter the data in the blank worksheet according to your needs. Here I have created the data HP sales table 2009-2010 in tabular form.
4. Then, table block is like the image below. choose Insert on the menu bar. In the Insert menu, there will appear other menus including graphics. Click Recommended Charts.
C. Selecting the Graphic Type
5. After that, a pop-up dialog box will appear as shown below. Recommended Charts contains graphics recommended by Microsoft so that it is good in its application. Please select the chart according to your needs. Do not forget click OK.
Or you can also choose All Charts, where all the graphs will be displayed. Then, you just adjust to the table you have.
Another way in making a graph in Microsoft Excel is to click icon charts which is in the image below. Select the chart you will use by clicking the down arrow.
6. After clicking OK, the graph will appear. You can zoom in/out or move the graph as needed. Don’t forget to give your chart a title.
7. The results of the graph from the table above will be as shown below.
D. Editing Graphics As You Want
Is the graph editable? Certainly can! Follow the steps below.
8. Next, you can edit the image by clicking add icon on the top right of the graph. Previously, please click on the graph first to bring up the menu. Look at the picture below.
Choose what parts you need on the chart. For example, you want to remove the lines in the image. Click Gridlines, so that the check mark disappears.
9. You can also change style nor color from the graph by clicking draw icon on the top right of the graph.
Style useful for changing the type of graph you want.
Color useful for changing the color of the graph.
10. Finally, you can change the content and the name in the graph. Click filter icon on the top right of the graph.
Values useful forfilter an object of the graph to be displayed and not. Don’t forget to click apply, when you finish selecting.
Names useful for replacing the names listed on the graph. Don’t forget to click apply, when you finish selecting.
A few explanations about how to make a chart in excel easily. Hopefully it can help you in completing your work. Use graphs according to your needs to make it easier to read the data. Thank you and good luck with the tutorial on how to create charts in Excel above!
Book enthusiasts. Women with noisy minds, prefer to write rather than speak. Calm is my way.
){kind=link}
Post a Comment for "4+ How to Create Graphs in Microsoft Excel (Complete+Pictures)"