To make a chart in desktop Excel, select your data, choose Insert > Recommended Charts, pick a preview, and select OK. Then give the chart a clear title and check that it shows the categories and values you meant to compare. Excel calls these visuals charts; the steps below also answer the common question of how to make a graph.
Make a chart in desktop Excel
- Arrange your data. Put category labels beside the values they describe, with headings where useful. Keep the range continuous if possible so Excel can identify the data and series.
- Select the data. Click any cell inside a continuous data range; Excel can include the full range. For data in separate areas, select the relevant rectangular ranges together.
- Insert a suggested chart. Go to Insert > Recommended Charts, review the previews, select one, and confirm. Microsoft says, “Excel will analyze your data and make suggestions for you.” If the suggestions do not suit your purpose, open All Charts and choose another type. Microsoft’s chart-creation instructions cover Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016 across desktop and web workflows.
- Refine the chart. Select the chart to use chart controls or the Chart Design and Format tabs. Add a title or labels, adjust the style, or change which data appears.
- Check the result. Compare the displayed categories and values with the worksheet and ask whether the chart makes the intended comparison easy to understand.
Choose a chart type for the question
Recommended Charts is a useful starting point, not a substitute for deciding what comparison matters. The right form depends on the structure of the data and what readers should see. Microsoft’s overview of chart types describes the uses and features of common options.
As an Amazon Associate I earn from qualifying purchases.
| What you want to show | Chart to consider | Why it fits |
|---|---|---|
| Compare values across categories | Column chart | Categories typically appear on the horizontal axis and values on the vertical axis. |
| Show change across ordered periods | Line chart | The ordered horizontal axis makes movement over time easier to follow. |
| Show parts of a whole | Pie or doughnut chart, when there are only a few clear parts | Use it when the reader needs to see how categories contribute to one total. |
| Show the relationship between two numeric variables | Scatter chart | It plots paired numeric values to make their relationship visible. |
| Compare values or categories across geographic areas | Map chart | Microsoft describes map charts as a way to compare values or categories across regions. |
| Show the distribution of values | Box-and-whisker chart | It summarizes distributions using quartiles and can highlight means and outliers. |
These are choices to consider, not automatic rules: the chart should match both the data and the comparison you need to communicate.
Make the chart easier to read
- Use a descriptive title. Say what is being measured and, when relevant, the period or group.
- Add only useful labels. Axis titles, data labels, and a legend can clarify meaning; unnecessary labels compete with the data.
- Confirm the data series. Use Select Data to edit or rearrange the series if Excel interpreted the rows or columns differently from what you intended.
- Format specific elements as needed. The chart area, plot area, series, axes, titles, labels, and legend can be formatted through the Format task pane or Chart Tools Ribbon.
- Use filtering when it answers a real question. Chart filters can change the displayed data; check the result against the full source range so the view is not mistaken for the whole dataset.
Microsoft’s chart-formatting guide explains controls for chart elements and series.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
When to use a PivotChart
If you need to explore a large dataset by filtering for different subsets, consider a PivotChart. It includes filtering controls for examining part of the data. In Excel for the web, the Recommended Charts flow can insert either a regular chart on the source worksheet or a PivotChart with a new worksheet and PivotTable source. See Microsoft’s PivotChart instructions for details.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Excel on the web and mobile
The overall process is similar, but the controls differ from desktop Excel. On the web, Recommended Charts has a task-pane flow; Microsoft notes that this feature has language and subscription availability conditions. On mobile, select the data, open Insert, then choose Recommended or another chart type. Chart controls appear on a Chart tab and vary by device. Use Microsoft’s platform-specific Excel for the web chart guide and mobile chart guide for the controls available on your version.
Quick Recap
Rank #4
Troubleshoot a chart that looks wrong
- Only part of the data appears: select the chart and open Select Data to inspect or adjust the source range and series.
- Categories and values are reversed or confusing: use Select Data to review how the rows and columns are assigned to series and labels.
- The recommended chart does not fit: return to Insert > Recommended Charts, open All Charts, and select a form that better matches the comparison.
- The chart is hard to interpret: add a clear title, provide only the labels needed to identify values, and reconsider whether the chart type suits the data.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Recommended Free Tools
