Home » » How to Make Graphs in Microsoft Excel

How to Make Graphs in Microsoft Excel

How to Make Graphs in Microsoft Excel - yet know how to make graphs on microsoft excel? No confusion, as we will explain how. Graphs are created on Ms. Excel results will be very accurate. Different if we make the graph manually, it would be much different. As we all know, that can be a graphic display column, pie, bar, line, area, scatter and other.


HOW TO MAKE A GRAPH ON MICROSOFT EXCEL :


1.Frist make the data to be graphed in the from of table. For example, an image can be seen below.





2. Block area table starts B3 up to D15.



3. Open the Insert ribbon and then select the one desired chart form on menu group charts. For example, we select only the column with sub options form 2-D column as shown below.



4. How to create charts in Microsoft Excel is then automatically next chart will appear in the worksheet. You can see that between the graph and the data are connected. If you change the data in the table, it will automatically graph will also change. Now you can increase the size of the chart by dragging the corner towards the cart area and set out in accordance with the wishes. 



The steps above are the basic ways to create a chart in Microsoft Excel.


May be useful,,, :)
and do not forget to comment.


0 comments:

Post a Comment