7. PivotTables and PivotCharts
7.11 PivotCharts
Steps in Excel
- Click the PivotTable › PivotTable Analyze › Tools › PivotChart › choose Clustered Column › OK. (Or Insert › Charts › PivotChart directly from the Table.)
- The chart follows the pivot: changing fields, filters or slicers changes both.
- PivotChart Analyze › Show/Hide › Field Buttons – hide the grey buttons for a clean dashboard look.
- Move to its own sheet: Design › Location › Move Chart.
- Chart types not supported as PivotCharts include scatter, histogram, box & whisker, treemap, sunburst, waterfall and map – for those, use normal charts on a formula summary (Module 8).
Worked example. A column PivotChart of monthly sales by platform (Months grouped, Platform in Legend) with the City slicer connected – Salman shows Pune's September Ganeshotsav peak in the weekly review.
Ravindra Bagale's Tip
Many students build a dashboard leaving the field buttons on the PivotChart – it looks very cluttered. Hide the Field Buttons, write a clear title and use slicers. And if the pivot has too many rows (100 products), the chart can't be read at all – apply a Top 10 filter first.
Ravindra Bagale's Tip – मराठी
PivotChart वर field buttons तसेच ठेवून बरेच students dashboard बनवतात – ते खूप cluttered दिसतं. Field Buttons लपवा, title स्पष्ट लिहा आणि slicers वापरा. आणि pivot ला जास्त rows (100 products) असतील तर chart वाचताच येत नाही – आधी Top 10 filter लावा.
Ravindra Bagale's Tip – हिंदी
PivotChart पर field buttons वैसे ही छोड़कर बहुत से students dashboard बना देते हैं – वह बहुत cluttered दिखता है. Field Buttons छुपाओ, title साफ़ लिखो और slicers इस्तेमाल करो. और pivot में बहुत ज़्यादा rows (100 products) हों तो chart पढ़ा ही नहीं जाता – पहले Top 10 filter लगाओ.
Worked example — pivotcharts
Why
Priya Deshmukh in Pune and Carlos Rivera abroad both need a clear, repeatable way to use pivotcharts on a QuickCart Delivery sheet without breaking totals.
What
Pivotcharts is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for pivotcharts.
- Enter a small made-up value for Priya Deshmukh using ₹ where money appears.
- Add a second value for Carlos Rivera using € so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once pivotcharts is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of pivotcharts on a blank sheet for Pearl Textiles.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Vikram Rao and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Anna Kowalski.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply pivotcharts to a 5-row made-up Pearl Textiles table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with pivotcharts.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as PearlTextil_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
