Charts
Choose charts according to the question being answered.
|
Requirement |
Suitable Chart |
|
Compare products |
Column / Bar |
|
Sales trend |
Line |
|
Category contribution |
Doughnut / Pie |
|
Monthly performance |
Line |
|
Employee comparison |
Bar |
|
Multiple metrics |
Combination Chart |
Key Rule
Do not use a chart simply because it looks attractive. Choose it based on the information you want the user to understand.
PivotCharts
PivotCharts are connected to PivotTables and work well with:
- Slicers
- Timelines
- PivotTable filters
Example
Rows: Product
Values: Sales
Create a Column PivotChart to compare product sales.
Practice
Create:
- Product Sales Chart
- Monthly Sales Chart
- City Sales PivotChart