Creating Basic Charts in Microsoft Excel
- Feb 20
- 3 min read
1. Introduction to Charts in Excel
Charts help you:
✔ Visualise data clearly
✔ Identify trends
✔ Compare performance
✔ Present financial information professionally
✔ Improve reports and dashboards
In finance and business, charts make reports easier to understand for managers and stakeholders.
2. When Should You Use a Chart?
Use charts when you want to:
Compare monthly sales
Show profit trends
Compare expenses
Present financial performance
Analyse growth over time
Avoid charts when presenting very detailed numerical breakdowns — use tables instead.
3. Preparing Data for a Chart
Before creating a chart:
✔ Ensure data is organised in a table format
✔ Include clear headings
✔ Avoid blank rows or columns
Example data:
Month | Sales |
Jan | 5,000 |
Feb | 7,000 |
Mar | 6,000 |
Headings are important — Excel uses them automatically in charts.
4. Creating a Basic Column Chart (Most Common)
Step 1:
Select your data (including headings).
Step 2:
Click the Insert tab.
Step 3:
Go to the Charts group.
Step 4:
Click Column Chart.
Step 5:
Select Clustered Column.
Excel will automatically generate your chart.
✔ Best for comparing categories
✔ Common in financial reports
5. Creating a Line Chart (Trend Analysis)
Used for showing trends over time.
Steps:
Select data.
Click Insert.
Choose Line Chart.
Select basic Line.
✔ Best for:
Monthly revenue
Profit trends
Forecasting
6. Creating a Pie Chart (Proportions)
Used to show parts of a whole.
Example:
Expense Type | Amount |
Rent | 2,000 |
Utilities | 500 |
Supplies | 300 |
Steps:
Select data.
Click Insert.
Choose Pie Chart.
Select 2-D Pie.
✔ Good for expense breakdown⚠ Avoid using with too many categories
7. Moving and Resizing Charts
To move:
Click and drag the chart.
To resize:
Click the chart.
Drag corner handles.
Professional Tip: Keep charts proportional and centred.
8. Adding a Chart Title
Click the chart.
Click Chart Title.
Type a meaningful title.
Instead of: "Chart 1"
Use:" Monthly Sales – Q1 2026"
Always make titles clear and professional.
9. Adding Data Labels
To show values on the chart:
Click the chart.
Click the "+" (Chart Elements button).
Tick Data Labels.
Used when presenting financial results.
10. Changing Chart Style
Click the chart.
Go to Chart Design tab.
Choose a style.
Best Practice:
✔ Use clean and simple designs
✔ Avoid overly bright colours
✔ Keep consistent formatting
11. Editing Chart Data
If numbers change:
Excel updates automatically.
To edit data source:
Right-click chart.
Click Select Data.
Adjust range if necessary.
12. Moving Chart to a New Sheet
For reports:
Click chart.
Go to Chart Design.
Click Move Chart.
Select New Sheet.
Name it (e.g., Sales Chart).
Useful in dashboards.
13. Example Business Application
Scenario:
You work in Accounts and need to present:
Monthly Sales
Monthly Expenses
Quarterly Profit
You would use:
Column Chart → Compare months
Line Chart → Show trend
Pie Chart → Expense breakdown
Charts improve decision-making.
14. Practice Exercise
Create this table:
Month | Revenue |
Jan | 10,000 |
Feb | 12,000 |
Mar | 9,500 |
Apr | 13,000 |
Tasks:
Create a Column Chart.
Add a professional title.
Add data labels.
Resize neatly.
Move chart below the table.
Bonus: Create a Line Chart using the same data.
15. Common Mistakes to Avoid
❌ Too many colours
❌ No title
❌ Poor data layout
❌ Overcrowded pie charts
❌ Unclear axis labels
16. Knowledge Check Questions
Which chart type is best for trends over time?
Why must headings be included?
When is a pie chart appropriate?
Why are charts important in finance?
17. Key Takeaways
✔ Charts turn numbers into visual insights
✔ Column charts compare categories
✔ Line charts show trends
✔ Pie charts show proportions
✔ Clean presentation is essential in business
Comments