📎 This article includes 1 downloadable practice file ↓
Excel’s default chart is a starting point. Five minutes of clean-up makes it look professional, and a saved template makes the next one instant.
Column or bar chart
- Select Products!A1:B7, Insert › Bar (labels are long, so horizontal bars read better).
- Sort the data largest first (or reverse category order on the axis) so the biggest bar is on top.
- Format the bars: Gap width 50-80% for solid bars.
- Add data labels; delete gridlines and the value axis if labels show the numbers.
- Write a title that states the point.
Line chart for a trend
Select Monthly!A1:E13 › Insert › Line. Four regions, twelve months. Thin lines, one highlighted region in colour and the rest grey, labels at the line ends instead of a legend.
💡 Right-click a finished chart > Save as Template. Next time choose Insert > Charts > All Charts > Templates and every format is applied.
Axis tips
- Number format on the axis:
#,##0, or0" L"for lakhs already divided. - Line charts can start above zero to show variation; columns must start at zero.
- Months as text in order on the axis; dates as real dates for time scaling.
Where people go wrong
| Problem | Fix |
|---|---|
| Years plotted as a series | Clear the header above the year column or use Select Data |
| Legend far from lines | Label line ends |
| Thin, gappy columns | Reduce gap width |
Practice
Build a sorted bar chart from the Products sheet and a line chart from the Monthly sheet, then save one as a template.
📎 Practice files for this article
- 📗Charts practice dataMonthly regional sales, target, online share and product data.⬇ XLSX · 7 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong