Easy: Wrong chart data range
Absolute refsNumbers as textLeading spacesFilter left onChart range% vs decimalDuplicate headerROUND vs displayFreeze panesPaste valuesVLOOKUP & textVLOOKUP col indexHLOOKUP TRUESUMIF spacesCOUNTIFS ORIF nest orderDate serialINDEX MATCHWildcard COUNTIFMixed currencyCircular & datesCircular interest3D sum renameNamed range staleCF vs IFPivot staleHard-coded NPVValidation movedPQ step orderTyped-over formulaSUM wrong anchorsFiscal year Apr–MarFind all bugsInterview oral
The bar chart used A4:B9 — so “Month” appears as a category and June is missing. Point the chart at A5:B10 (or use titles_from_data correctly).
Chart A4:B9 वापरते — “Month” category होते, June राहून जाते. A5:B10 निवडा.
Chart ने A4:B9 लिया — “Month” category बन गई, June छूट गई। A5:B10 चुनें।
About this data: Made-up monthly sales for Sneha Kulkarni (Nagpur) and Carlos Silva (Lisbon). Practice only.
Why → What → How
Why: Charts built by dragging too far/short mislead managers in meetings.
What: Jan–Jun sales; broken chart misses Jun and treats header as a point.
How:
- Open Monthly and select the chart.
- Chart → Select Data — note range.
- Set values to B5:B10, cats A5:A10.
- Confirm six bars including Jun.
Ravindra Bagale’s Tip
After editing months, right-click chart → Select Data and re-check the range every time.
Ravindra Bagale’s Tip – मराठी
Months बदतल्यानंतर Select Data ने range पुन्हा तपासा.
Ravindra Bagale’s Tip – हिंदी
Months बदलने के बाद Select Data से range फिर जाँचो।
Bugs explained (with mini examples)
Bug 1 — Header as category
Cats started at A4 → literal "Month".
Bug 2 — Missing last month
Max row 9 missed Jun (row 10).
Practice tasks (12)
- Task 1. How many bars on the broken chart?Hint: Likely 5 + weird header.
- Task 2. Name the missing month.Hint: Jun.
- Task 3. Fix category range.Hint: A5:A10.
- Task 4. Fix value range.Hint: B5:B10.
- Task 5. Confirm Jun 58 appears.Hint: Yes.
- Task 6. Why is header-as-category bad?Hint: Nonsense axis label.
- Task 7. Rebuild chart from scratch if needed.Hint: Insert → Chart.
- Task 8. Interview sentence.Hint: “Chart range missed June.”
- Task 9. Add Jul 64 — extend range.Hint: A5:B11.
- Task 10. Do not include totals row in chart.Hint: Skew.
- Task 11. Use a Table so charts expand.Hint: Nice habit.
- Task 12. Bonus: add data labels.Hint: Optional.
Step-by-step solution (try first)
- Select Data → categories A5:A10, values B5:B10.
- Six months including Jun=58.
Quick quiz
Q1. Including the header row as a category shows:
Q2. Missing the last month means the range was:
Q3. Jun sales in this file:
Q4. Best habit after adding a month:
Q5. Charts should usually exclude: