Detailed instructions on how to graph in excel

Today I would like to introduce how to create graphs in excel. Graphs in excel help present figures by drawing into visual, easy to understand images. The graph is linked to its data in a spreadsheet, so when changing its data in a spreadsheet, the chart itself changes. The graph is an object of excel, this object contains data and image representation with very rich colors.

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 machine.

Data of the graph

Step 2: You only need to scan the data you want to chart.Then choose Insert-> Column, here I draw the new column chart, select the column.If you want 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 on 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.

Good luck!