# Chart Formatting

Course: [Excel](https://www.devtutorials.ai/learn/excel) · Section: Visualizing Data
Source: https://www.devtutorials.ai/learn/excel/visualizing-data/chart-formatting

> Add chart titles, data labels, legends, and axis titles, and change chart styles and colors.

A chart without a title or labels leaves readers guessing: sales of what? In which units? A few finishing touches make a chart clear enough to understand without any explanation. In this lesson, you'll add a chart title, data labels, a legend, and axis titles, and change chart styles and colors.

Open the **Excel sandbox** and follow along. Select a chart to see the chart tools: in Excel, the **Chart Design** and **Format** tabs, plus the **+** (Chart Elements) button beside the chart.

## Chart title

The **title** tells readers what the chart shows. Make it specific: `Monthly Sales 2026 (USD)` is better than `Chart Title`.

- Click the existing title on the chart and type a new one, or
- Use **Add Chart Element** > **Chart Title** to add or place it.

## Data labels

**Data labels** show each value on its bar, point, or slice, so readers do not have to guess from the axis.

Use **Add Chart Element** > **Data Labels** and choose a position, such as **Outside End**.

Data labels work well for a few bars or pie slices. With many points, they can make the chart messy, so use the axis instead.

## Legend

The **legend** is the key that shows which color belongs to which series. It is important when a chart has more than one series, like Sales and Costs.

- **Add Chart Element** > **Legend**, then choose **Top**, **Bottom**, **Left**, **Right**, or **None**.
- With a **single** series, the legend only repeats the title, so you can hide it.

## Axis titles

**Axis titles** say what each axis measures and in what units: `Month` along the bottom, `Sales (USD)` up the side.

Use **Add Chart Element** > **Axis Titles**, choose **Primary Horizontal** and **Primary Vertical**, then click each title and type.

A good chart answers three questions without any extra text: **what** it shows (title), **what each axis measures** (axis titles, with units), and **which series is which** (legend). Check these before you share any chart.

## Chart styles

**Chart styles** are ready-made looks for charts, such as backgrounds, gridlines, and effects. In Excel, select the chart and pick a style from the **Chart Styles** gallery on the **Chart Design** tab. Choose simple, clean styles; strong 3-D effects can make values harder to read.

## Chart colors

In Excel, **Chart Design** > **Change Colors** applies a color palette to the whole chart. To color one series or one bar, select it, then use **Format** > **Shape Fill**.

The sandbox's chart tools focus on chart type, title, axis titles, legend, and data labels, and may not have a style gallery or color palettes. Practice styles and colors in Excel; everything else in this lesson works in the sandbox.

## Common mistakes

| Mistake | What happens | How to fix it |
|---|---|---|
| Default title left in place | The chart says "Chart Title" | Click the title and type a real one |
| No units on the axis | Readers can't tell dollars from thousands | Add an axis title like "Sales (USD)" |
| Legend hidden on a multi-series chart | Readers can't tell series apart | Turn the legend back on |
| Too many data labels | The chart is cluttered and hard to read | Remove labels, or keep only key ones |
| Similar colors for different series | Series look alike | Pick clearly different colors |

## Exercise

Click **Reset** in the sandbox header. Type this table in **A1:B5** and insert a **column** chart from it:

- `Fruit`, `Sold`
- `Apples`, `45`
- `Bananas`, `60`
- `Cherries`, `25`
- `Dates`, `35`

Then do each task and press **Check**.

## What to remember

- Every chart needs a specific **title**.
- **Axis titles** say what each axis measures, with units.
- A **legend** identifies series; hide it when there's only one.
- **Data labels** show exact values; use them sparingly.
- **Chart styles** and **colors** change the look; keep them simple and readable.

In the next lesson, you'll color cells automatically with conditional formatting.