How to Create Charts in Excel: The Complete Guide (2026)

A wall of numbers rarely tells a story on its own — but turn that same data into a chart, and trends, comparisons, and outliers jump out instantly. Whether you’re building a sales dashboard, a budget tracker, or a quarterly report for your manager, Excel gives you several reliable paths from raw cells to a polished, professional chart, and the whole process takes just a few minutes once you know where to look.

This guide walks through every method of creating a chart in Excel — using Recommended Charts, manually picking a chart type, and the one-key shortcut — plus how to customize, format, and even update your chart automatically as your data changes.

Step 1: Prepare and Select Your Data

Before you touch the Insert tab, get your data into good shape:

1. Make sure your data is organized in a simple table structure, with column headers in the first row (like “Month,” “Region,” “Revenue”).
2. Select the range of cells you want to visualize, including the header row if you want those labels to appear in your chart’s legend or axis.
3. If your data isn’t contiguous — say, you only want two out of five columns — hold Ctrl (Windows) or Command (Mac) while selecting each range separately.

Choosing the right data is genuinely the most important step in the whole process, since a chart is only as clear as the data feeding into it.

Method 1: Using Recommended Charts (Best for Beginners)

This is Excel’s built-in feature for suggesting the most sensible chart type based on the shape and content of your selected data.

1. Select your data range.
2. Go to the Insert tab on the ribbon.
3. Click Recommended Charts in the Charts group.
4. Excel will open the Recommended Charts pane, showing several chart types tailored to your specific dataset.
5. Click through each suggestion in the list to preview how your data would look in that format.
6. If none of the suggestions feel right, click All Charts at the top of the dialog to browse every available chart type.
7. Once you’ve found the one you want, click it, then click OK to insert it into your worksheet.

Recommended Charts is available to Microsoft 365 subscribers and currently supports several languages including English, French, Spanish, German, Simplified Chinese, and Japanese — if you’re on an older, non-subscription version of Excel, this specific feature may not be available, though the manual method below always works regardless of your version.

Trying It With Sample Data First

If you want to explore how Recommended Charts works without touching your own data yet:

1. Go to Insert > Recommended Charts.
2. Click the Try sample data button.
3. Excel will populate your worksheet with placeholder data, analyze it, and show you a set of recommended charts based on that sample — a good way to get a feel for the feature before using it on your real dataset.

Method 2: Manually Choosing a Chart Type

If you already know exactly which chart type you want — a column chart to compare categories, a line chart to show a trend over time, a pie chart for parts of a whole — you can skip the recommendation step entirely:

1. Select your data range, including headers.
2. Go to the Insert tab.
3. In the Charts group, click the icon for your preferred chart category (Column, Line, Pie, Bar, and so on) — each icon shows a small dropdown with several subtypes (like clustered column, stacked column, or 100% stacked column).
4. Click the specific subtype you want.
5. Excel inserts the chart directly onto your worksheet, and you can click and drag it to reposition it anywhere on the sheet.

To see every single chart type Excel supports in one place — including less common options like Waterfall, Surface, Treemap, and Combo charts — click the small dialog launcher arrow in the corner of the Charts group to open the full Insert Chart dialog box.

Method 3: The One-Key Shortcut

If you’re in a hurry and just want a quick visual without thinking too hard about chart type:

1. Select your data.
2. Press Alt + F1.

This instantly inserts a default chart (typically a clustered column chart) directly onto your current worksheet. It’s the fastest method available, though keep in mind it might not be the ideal chart type for your specific data — it’s meant as a quick, rough visualization rather than a final, polished result.

Common Chart Types and When to Use Them

Choosing the right chart type matters as much as the steps to create it. A few quick guidelines:

• Column or bar charts — best for comparing values across different categories, like sales by region or scores by student.
• Line charts — ideal for showing trends and changes over a continuous period, like monthly revenue across a year.
• Pie charts — useful for showing parts of a whole, such as market share split among a handful of competitors, though they work best with a small number of categories.
• Scatter plots — best suited for showing correlation or relationships between two numeric variables.
• Combo charts — combine two chart types (like columns and a line) in a single chart, useful when you want to compare two different measures with different scales, such as revenue (columns) against growth rate (a line).
• Waterfall charts — good for showing a running total that increases and decreases in sequential steps, like a profit-and-loss breakdown.
• Surface and 3D charts — used less frequently, generally for more advanced datasets involving three variables or a spatial relationship between values.

If you’re ever unsure, switching between a few different chart types using the Change Chart Type dialog (covered below) is a quick way to see which one actually communicates your data most clearly.

Customizing and Formatting Your Chart

Once your chart is inserted, Excel reveals additional contextual tools specifically for working with it.

Chart Tools Ribbon

Click anywhere inside your chart to reveal the Chart Design and Format tabs on the ribbon. These give you access to:

• Chart Styles — a gallery of pre-built color and style combinations you can apply with one click.
• Change Colors — swap out the overall color palette used across your chart’s data series.
• Switch Row/Column — flips which axis represents your categories versus your data series, useful if your chart initially looks backwards from what you intended.
• Select Data — lets you adjust exactly which cells feed into the chart, add new data series, or remove ones you no longer want included.

Adding Chart Elements

Next to the upper-right corner of any selected chart, you’ll see a small + (plus) icon — this is the Chart Elements button, and it lets you toggle on or off:

• Axis Titles — labels describing what each axis represents.
• Chart Title — a title displayed above the chart itself.
• Data Labels — the actual numeric values displayed directly on each bar, line point, or pie slice.
• Gridlines — horizontal or vertical reference lines behind your chart’s data.
• Legend — the key identifying which color corresponds to which data series.
• Trendline — a line showing the general direction of your data over time, useful for highlighting an overall trend within scattered data points.

Simply check or uncheck any of these boxes to add or remove them from your chart instantly.

Changing the Chart Type After Creation

If you’ve already inserted a chart but decide a different type would communicate your data better:

1. Click on the chart to select it.
2. Browse the available chart types and subtypes in the dialog that appears.
3. Select your preferred option and click OK — your existing data automatically carries over into the new chart type.

Creating a Chart on Its Own (Blank Canvas Method)

If you’d rather build a chart structure first and add data afterward:

1. Click on an empty cell in your worksheet.
2. Go to the Insert tab and select your preferred chart type from the Charts group.
3. Excel inserts an empty chart canvas with no data yet.

This approach is less common than starting with data already selected, but can be useful in specific templated report layouts where the chart’s position is fixed before the data is finalized.

Making Your Chart Update Automatically

One of the most valuable things about Excel charts is that they aren’t static images — by default, a chart built directly from a cell range updates automatically whenever the source data changes. To make the most of this:

• Use Excel Tables (Ctrl+T) for your source data rather than a plain range, since tables automatically expand your chart’s data range as new rows are added, without needing to manually adjust the chart’s reference each time.
• Avoid hardcoding specific numbers into chart titles or labels if you want everything, including labels, to stay dynamic and reflect updated data automatically.

Reusing and Exporting Your Chart

• Save a chart as a reusable template: Right-click your finished chart and select Save as Template, letting you apply the same formatted style to new charts in future workbooks without rebuilding it from scratch.
• Copy as a static image: Right-click the chart and choose Copy, then paste it elsewhere as a picture if you want a snapshot that won’t update when the source data changes.
• Paste-link into PowerPoint or Word: Instead of a regular paste, use Paste Special > Paste Link when pasting into another Office application, so the chart automatically refreshes in that document whenever the original Excel data updates.

Using Copilot to Create Charts (If Available)

If your version of Excel includes Microsoft’s Copilot AI features, you can also generate charts using natural language prompts rather than manually navigating the ribbon — for example, describing the chart you want in plain English and letting Copilot build it based on your selected data. Note that Microsoft has recently renamed and reorganized some of these AI features, so if you come across an older tutorial referencing “App Skills” or “Agent Mode,” those specific names have since been retired in favor of a simpler “Edit with Copilot” experience. Since this feature set changes frequently and isn’t available on every plan or version, check your specific Excel edition’s ribbon for a Copilot icon if you want to try this route.

Troubleshooting Common Chart Issues

• The chart doesn’t include the data I expected. Click Select Data under Chart Design to review and adjust exactly which ranges are being plotted.
• My chart looks backwards (categories and series are swapped). Use Switch Row/Column under Chart Design to flip the orientation.
• New rows of data aren’t automatically appearing in my chart. This usually means your source data is a plain range rather than a formatted Excel Table — convert your range to a table with Ctrl+T so the chart’s reference expands automatically.
• Recommended Charts option is missing. This feature requires a Microsoft 365 subscription and an up-to-date version of Excel; older perpetual-license versions may not include it, though manually inserting a chart type always remains available.
• My chart type doesn’t clearly show what I’m trying to communicate. Don’t hesitate to try a few different chart types using Change Chart Type — the “right” chart is often a matter of testing a couple of options until the message clicks visually.

Frequently Asked Questions

1. What’s the fastest way to create a chart in Excel? Select your data and press Alt+F1, which instantly inserts a default chart. It’s quick but not always the ideal chart type, so it’s best for a rough first look rather than a polished final chart.

2. How do I let Excel choose the best chart type for my data? Select your data, go to Insert > Recommended Charts, and Excel will analyze your selection and suggest several chart types tailored to it.

3. Can I add a chart title, axis labels, or data labels after the chart is already created? Yes. Click the chart to select it, then click the “+” (Chart Elements) button near the top-right corner of the chart to toggle on titles, labels, gridlines, legends, and more.

4. How do I change my chart’s type after I’ve already created it? Click the chart, go to Chart Design > Change Chart Type, and select a different chart type — your existing data will automatically carry over.

5. Why doesn’t my chart update when I add new rows of data? This typically happens when your source data is a plain cell range rather than a formatted Excel Table. Converting your data range into a table with Ctrl+T allows the chart to expand automatically as new data is added.

6. Can I combine two different chart types in a single chart? Yes, using a Combo chart, which lets you display, for example, columns and a line together in the same chart — useful when comparing two measures with very different scales.

7. Is the Recommended Charts feature available in every version of Excel? No. It’s available to Microsoft 365 subscribers with an up-to-date version of Excel, in a specific set of supported languages. Older, non-subscription versions may not include this feature, though manual chart creation always works regardless of version.

8. How can I reuse a chart’s exact formatting and style for a different dataset later? Right-click your finished chart and select Save as Template, which lets you apply that same design to new charts in future workbooks without rebuilding the formatting from scratch.

Conclusion

Creating a chart in Excel takes just a few clicks, whether you let Recommended Charts do the thinking for you, manually pick a specific chart type, or use the Alt+F1 shortcut for a quick, rough visual. The real value comes afterward, in the customization — adding clear titles, the right labels, and choosing a chart type that actually fits the story your data is trying to tell. And if you set things up with an Excel Table as your data source, your chart stays current automatically, turning a one-time visual into a living part of your report that updates right alongside your numbers.