Skip to content
Back to template gallery
Microsoft Excel
Microsoft Excel

How to create charts in Excel

Learn how to insert and customize a column chart in Microsoft Excel. This step-by-step guide will walk you through selecting your data, inserting a chart, and applying a styled theme to visually enhance your presentation.

Operations
6 steps 2 min Community template
1

Open or Navigate to Excel window

Open Microsoft Excel or switch to the active Excel window on your taskbar to begin editing your worksheet.

www.microsoft.com
Open or Navigate to Excel window
2

Select the data you want to include in the chart

Highlight the cell range or data set you want to visualize in your spreadsheet.

www.microsoft.com
Select the data you want to include in the chart
3

Click the Insert tab

Click the Insert tab in the top ribbon to access options for adding elements to your spreadsheet.

www.microsoft.com
Click the Insert tab
4

Go to chart panel

In the Charts section, choose a chart type: Column/Bar — compare categories. Line — show changes over time. Pie — show parts of a whole. Scatter — show relationships between two numerical variables

www.microsoft.com
Go to chart panel
5

Select the 3-D Stacked Column option

Click the second icon under the 3-D Column heading in the chart menu to apply this chart style.

www.microsoft.com
Select the 3-D Stacked Column option
6

Click the chart style you want.

Click the chart style you want. Excel will insert the chart automatically

www.microsoft.com
Click the chart style you want.

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.