Types
of Graphs in Excel
Bar Graphs
It is easier to compare values; it can be
seen in 3D.
Line Graphs
The line graph displays the trend of the
contribution of each value over categories. Also you can use it when you want
to compare data between years.
Scatter Plot Graphs
It is very similar to the Line Graphs; it
is used to compare numeric values.
Pie Charts
A pie chart has a circular form, it make up
the data proportional to the sum of the items.
Area Charts
The area area displays the percentage, and
the colors can make us understand better the graph.
Doughnut Charts
The doughnut chart displays the data in
rings, where each ring represents a data series.
Radar Chart
A radar chart compares the different values
of a number of data series.
Surface Charts
A surface chart is useful when you want to
make combinations between two sets of data.
Bubble Charts
In Company A, the bubble means that it has
the most number of products, but it is not the best sale.
Why are graphs useful?
they are useful because you can compare different data in a visual way.
How To Use Formulas
Average: add a group of numbers, for
example the average of 2,3,3,5,7, and 10 is divided by 6, which is by 5.
=AVERAGE(11+12+13+14+15+16)/6
Example:
Example:
Sum: you add a group of numbers using the formula
=SUM(114+165+178+143+130+165)
Example:
Why are formulas useful?
they are useful because you can calculate the answer of numbers that are very big and it will take you less time than even in the calculator, also you can do graphs to see your data in a visual way.
For More Explanation:
How to use formulas and graphs