Construction - Good chart

Page visited 13085 times

 
1. Wich graph for what kind of use ?
Excel-Exercise-Tutorial-1
 
 
 
2. The bar (horizontals or verticals like the column)
Bar charts are typically used to compare values between categories rather than a time period
Excel-Exercise-Tutorial-2
 
 
 
3. The stacked bars
They are especially used to compare the growth, the increase of similar data (always for purcentage).
Frequent mistake : It is not recommended to select more than 4 or 5 items otherwise it's difficult to read your chart
Excel-Exercise-Tutorial-3
 
 
 
4. The line charts
Most generally use to present data on a time period : stocks variation, population evolution, stocks, ...
This type of chart is often use with other types of chart to highltight your result
Excel-Exercise-Tutorial-4
 
 
 
5. Pies
Pie charts are typically used to show percentages. Frequent mistake : When you have several small pieces it is not possible to read them. It is more convenient to gather all these slides in a single one
Excel-Exercise-Tutorial-5
 
 
 
6. Radar or spiderweb chart
displays differences between several factors all related to one item. Radar charts have multiple axes along which data can be plotted.
Excel-Exercise-Tutorial-6
 
 
 
7. Area
These charts are similar to line charts but you highlight the amplitude or the or the fluctuation of the value rather than the time period
Excel-Exercise-Tutorial-7
 
 
 
8. Scatter
Scatter charts are typically used to compare aggregated data across categories.
Excel-Exercise-Tutorial-8
 
 
 
9. Les Bulles
A bubble chart displays each value series as data points in the chart space according to the X and Y values for the value series.
A third value, Size, determines the size of the symbol for the data point.
Excel-Exercise-Tutorial-9