Chart Formatting
By the Syncfusion DevTutorials team · Last updated
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,SoldApples,45Bananas,60Cherries,25Dates,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.