Getting Familiar with Different Visuals Available in Excel and When to Use Them

Excel visuals (charts and graphs) help you see patterns, trends, and comparisons instead of just looking at numbers.

Think of visuals as:

Turning numbers into pictures that are easier to understand.

1️⃣ Why Use Visuals in Excel?

Instead of this:

| Month | Sales |
|-------|-------|
| Jan   | 2000  |
| Feb   | 2500  |
| Mar   | 3000  |
| Apr   | 2800  |
| May   | 3500  |

A chart helps you quickly see:

• Sales are increasing
• April slightly dropped
• May is the highest

Visuals make reports:

• Easier to understand
• More professional
• Faster to analyze

2️⃣ Main Types of Visuals in Excel

We’ll cover the most important ones:

1. Column Chart
2. Bar Chart
3. Line Chart
4. Pie Chart
5. Area Chart
6. Scatter Plot
7. Combo Chart
8. Histogram

3️⃣ Column Chart

What It Looks Like

Vertical bars.

✅ When to Use It

• Comparing categories
• Comparing sales per month
• Comparing employees’ performance

Example Dataset:

| Product | Sales |
|---------|-------|
| A       | 5000  |
| B       | 7000  |
| C       | 6000  |
| D       | 8000  |

Use a Column Chart to compare which product sells more.

4️⃣ Bar Chart

What It Looks Like

Horizontal bars.

✅ When to Use It

• Long category names
• Ranking items
• Comparing many categories

Bar chart is similar to column chart but rotated.

5️⃣ Line Chart

What It Looks Like

Points connected with a line.

✅ When to Use It

• Showing trends over time
• Monthly revenue
• Website traffic
• Stock prices

Example:

| Month | Revenue |
|-------|---------|
| Jan   | 1000    |
| Feb   | 1500    |
| Mar   | 2000    |
| Apr   | 2500    |
| May   | 3000    |

Use a Line Chart to see growth trend.

Best for:

• Time-based data
• Continuous data

6️⃣ Pie Chart

What It Looks Like

A circle divided into slices.

✅ When to Use It

• Showing percentages
• Showing proportions
• Showing parts of a whole

Example:

| Category | Percentage |
|----------|------------|
| Food     | 40%        |
| Rent     | 30%        |
| Transport| 15%        |
| Savings  | 15%        |

Pie chart shows:

• Food takes the biggest portion

⚠️ Use pie chart only when:

• Few categories (less than 6)
• Data adds up to 100%

7️⃣ Area Chart

What It Looks Like

Like a filled line chart.

✅ When to Use It

• Showing total over time
• Showing cumulative values
• Showing volume change

It emphasizes quantity.

8️⃣ Scatter Plot (XY Chart)

What It Looks Like

Dots on a graph.

✅ When to Use It

• Showing relationship between two numbers
• Correlation analysis

Example:

| Hours Studied | Score |
|---------------|-------|
| 2             | 50    |
| 4             | 60    |
| 6             | 70    |
| 8             | 85    |
| 10            | 95    |

Scatter plot shows:

• More study hours → higher score

Used in:

• Statistics
• Data analysis
• Research

9️⃣ Combo Chart

What It Does

Combines two charts.

Example:

• Column for Sales
• Line for Profit %

Example:

| Month | Sales | Profit % |
|-------|-------|----------|
| Jan   | 5000  | 10%      |
| Feb   | 6000  | 12%      |
| Mar   | 7000  | 15%      |

Use Combo Chart when:

• Comparing two different types of values
• Values have different scales

🔟 Histogram

What It Does

Groups numbers into ranges.

Used for:

• Distribution analysis
• Exam scores
• Age distribution

Example:

Instead of showing each score individually,

it shows how many fall between:

• 0–50
• 50–70
• 70–90

1️⃣1️⃣ Quick Comparison Table

| Chart Type     | Best Used For                     |
|---------------|------------------------------------|
| Column Chart  | Comparing categories               |
| Bar Chart     | Ranking with long names            |
| Line Chart    | Trends over time                   |
| Pie Chart     | Showing proportions (few items)    |
| Area Chart    | Showing volume over time           |
| Scatter Plot  | Relationship between variables     |
| Combo Chart   | Comparing two different metrics    |
| Histogram     | Data distribution                  |

1️⃣2️⃣ How to Insert a Chart in Excel

1. Select your data
2. Go to Insert tab
3. Choose chart type
4. Customize title, labels, colors

No formulas required.

1️⃣3️⃣ Common Mistakes Beginners Make

• Using pie charts with too many categories
• Using line charts for non-time data
• Not labeling axes
• Not adding titles
• Using too many colors

1️⃣4️⃣ Choosing the Right Chart (Simple Rule)

Ask yourself:

| Question              | Chart Type   |
|-----------------------|--------------|
| Compare categories?   | Column / Bar |
| Show trend over time? | Line         |
| Show parts of whole?  | Pie          |
| Show relationship?    | Scatter      |
| Show distribution?    | Histogram    |