How to Create Any Chart in Excel (Complete Guide)

The four most useful chart types

Chart type	Best for	Avoid when
Column / Bar	Comparing values across categories	More than 8-10 categories
Line	Showing change over time	Non-time series data
Pie / Donut	Showing parts of a whole (max 5 slices)	More than 5 categories or when differences are small
Scatter	Showing relationship between two numeric variables	Categorical data

How to insert a chart

Select your data including headers

Insert → Charts → choose your type

Or press Alt+F1 for an instant default chart.

Use Chart Design tab to refine

Change type, colours, layout. Add or remove chart elements from the + button.

Essential chart formatting

Title — describe what the chart shows, not just "Sales Data"
Axis titles — label units so readers know what they're looking at
Start Y-axis at zero for comparison charts — right-click axis → Format Axis → set Minimum to 0
Remove gridlines for cleaner presentations — click gridlines → Delete
Data labels — right-click a bar/line → Add Data Labels for exact values

Keep charts updated automatically

Charts linked to Excel Tables (not plain ranges) update automatically when new data is added. Convert your data source to a Table (Ctrl+T) before inserting the chart.

⚠️ Avoid 3D charts

3D effects make bars look different sizes than they are. The depth distorts comparisons. Use flat 2D charts for any data where accuracy matters.

Practice what you just learned

ExcelPro has 880+ hands-on exercises across 9 tracks — type real formulas, get instant feedback.

Start practising free →

How to create any chartin Excel

The four most useful chart types

How to insert a chart

Essential chart formatting

Keep charts updated automatically

Practice what you just learned

How to create any chart
in Excel