
π This article includes 1 downloadable practice file β
In this article
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.
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.
Stuck on a step? Ask a question and the AI answers using this article.