How to Create a Chart in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to build and customize a chart in Microsoft Excel.

Quick summary

Creating a chart in Microsoft Excel involves selecting your dataset, using the Insert Chart menu to choose a chart type, and then customizing it through the Data and Format tabs to control axes, labels, and visual styling.

Steps

Select the cells containing the dataset you wish to visualize inside your Microsoft Excel worksheet.
Go to the top navigation bar and click 'Insert'.
Click the 'Insert Chart' menu to view all available chart selections.
Browse the provided options and select the chart type you prefer to use.
Return to the top menu bar and tap 'Chart' to access chart-level settings.
Choose 'Select Data' from the provided options to manage your data source.
Click the 'Data' tab to adjust the data source or configure the x-axis and y-axis settings.
Tap the 'Format' tab to change the formatting of the Chart Title, Legend, Horizontal Axis, Vertical Axis, and Series.
Once all settings are configured, your chart will be created based on your input and preferred design.

📌 Why this matters

Creating charts in Microsoft Excel is one of the most essential data visualization skills for analysts, business users, and students alike. Excel's built-in chart builder lets you transform raw spreadsheet data into clear, shareable visuals — including bar, line, and pie charts — in just a few clicks. The ability to customize axes, legends, and formatting through dedicated Data and Format tabs means users can produce publication-ready charts without any third-party tools. Mastering Excel chart creation directly improves how teams communicate insights and make data-driven decisions.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel