Detailed How to Graph in Excel

The graph in Excel helps us identify an overview of a problem or in other words, show the inventoried data

Guide Graphing

Types of Graphs

Column: Bar graph

Line: Line graph Pie: Pie chart Bar: Bar chart Area: Area chart XY (Scatter): XY chart (Scattered) Stock: Stock chart Bubble: Bubble chart Radar: Radar chart

How to Graph

Step 1: To draw a graph you must first create an existing data on the application.

Data of the graph

Step 2: You only need to scan the data you may need to chart. Then choose Insert-> Column, here I draw the new column chart, select the column. If you may need to draw another chart, choose another one. The following results:

On it is just a graph form. There are many other types, depending on the topic that you draw.

Add Title, Add Caption to Horizontal Axis, Vertical Axis

To add a title for the horizontal (or vertical) axis Chart Tools -> Layout -> Labels -> Axis Titles -> select a style from the list

Note

The Distance Between the Numbers on the Axis

For vertical axis, right-click the vertical axis and then select Format Axis. Then you go into that editing is according to the topic that edited. Above is the whole graphing method as well as correction in the graph, please refer to it.