June 29th, 2026
How to Create Charts in Excel: A Step-By-Step Guide for 2026
By Drew Hahn · 17 min read
Learning how to create charts in Excel is one of the fastest ways to make your data easier to understand. I've tested every major chart type across business datasets, and this guide walks you through the whole process from selecting your data to exporting a finished chart.
What you need before you start
Before Excel can build a chart, your data needs to be set up in a way that Excel can read correctly. A few small structural issues can cause charts to display incorrectly or pull in the wrong data, so it's worth checking these first:
Headers in the first row: Each column should have a clear label in the first row. Excel uses these labels to name your data series and axes automatically, which saves you from adding them manually later.
No blank rows or columns: Gaps inside your data range can cause Excel to treat your dataset as ending earlier than it does. Keep everything in one connected block with no empty rows or columns breaking it up.
Contiguous ranges: Your data should sit in one connected block of cells. If your data spans multiple non-adjacent ranges, hold Ctrl while selecting each range when you insert the chart.
As for data volume, Excel handles most standard business datasets without any issues. I’ve charted datasets with tens of thousands of rows and Excel can still render the chart, but performance and readability depend on your computer, Excel version, and how many points you plot at once. For larger datasets, consider summarizing or aggregating your data before you start charting.
How to create a chart in Excel: Step-by-step guide
The steps below cover the full process of creating a chart in Excel, from selecting your data to adding the finishing touches that make your chart easy to read.
Step 1: Select your data
Click the first cell in your data range, then drag to select all the cells you want to include in the chart. Make sure you include your header row so Excel can label your axes and data series automatically.
If your data isn't in one continuous block, hold Ctrl (Windows) or Command (Mac) while clicking each range to select multiple non-adjacent areas at once.
💡Tip: Select only the data you need. Highlighting extra empty cells or unrelated columns can pull unwanted data into your chart.
Step 2: Insert a chart
With your data selected, click the Insert tab on the ribbon. From here, you can either click a specific chart type from the Charts group or use the Recommended Charts option to let Excel suggest a chart based on your data.
Either path works. Recommended Charts is useful when you're not sure which chart type fits your data best.
Step 3: Use Recommended Charts vs. choose manually
Recommended Charts analyzes your data and suggests the chart types most likely to display it clearly. You can preview each suggestion before committing, which makes it a good starting point if you're working with an unfamiliar dataset.
If you have a specific chart type in mind, click the All Charts tab in the same window to browse the full list of available chart types for your version of Excel. I find this route faster when I already know what I want to build.
💡Tip: To skip the dialog entirely, select your data and press Alt + F1 on Windows, or Fn + Option + F1 on Mac, to insert a default chart in one keystroke. You can change the chart type afterward.
Step 4: Add a chart title
Click directly on the "Chart Title" placeholder text at the top of your chart and type your title. Keep it short and descriptive so readers know what they're looking at without having to study the chart first.
To move the title to a different position, click the Chart Elements button (the plus sign on Windows, or the chart layout options on Mac) on the right side of the chart and adjust the title placement from there.
Step 5: Add axis labels
Click the Chart Elements button on the right side of the chart, check the Axis Titles box, and type a label for each axis. Axis labels are especially important when your units aren't obvious from the data, such as revenue in thousands or time in weeks.
To turn off an individual axis label you don't need, uncheck the relevant option in the Axis Titles sub-menu without removing both at once.
Step 6: Adjust the legend
Excel adds a legend automatically when your chart has more than 1 data series. To move it, click the Chart Elements button, hover over Legend, and choose a position from the options that appear.
If your chart only has 1 data series, you can remove the legend entirely to keep the visual clean. Click the legend and press Delete.
Step 7: Add data labels
Data labels display the exact value of each data point directly on the chart, which can save readers from having to estimate from the axis. Click the Chart Elements button and check the Data Labels box to turn them on.
For charts with a lot of data points, data labels can make the chart look cluttered. Use them selectively, for the most important data series or a single data point you want to call out.
Which chart type should you use?
Change colors and chart styles
Click your chart, then select the Chart Design tab on the ribbon. From there you can browse preset styles and color schemes that apply across the whole chart in one click. To change the color of a specific data series, double-click it and select your preferred color from the Format Data Series panel on the right.
Switch rows and columns
Move and resize your chart
Add gridlines
Add a trendline
How to save and export a chart
Once your chart is ready, Excel gives you a few ways to save or share it, depending on where you need it to go. Here are three methods to export yours:
To save a chart as an image: Right-click the chart, select Save as Picture, choose your file format (PNG works best for most purposes), and save it to your preferred location.
To copy a chart into Word or PowerPoint: Click the chart, press Ctrl + C on Windows or Command + C on Mac, open your Word or PowerPoint file, and press Ctrl + V on Windows or Command + V on Mac to paste it. You can choose whether to keep the chart linked to your Excel data or embed it as a static image.
To export a chart as a PDF: Go to File, select Export, and choose Create PDF/XPS. If you only want to export the chart and not the whole workbook, select the chart first before going to File so Excel exports just that element.
💡Tip: If you paste a chart into PowerPoint as a linked object, it will update automatically when you change the underlying Excel data. Paste it as a static image if you want to lock the visual in place.
Common mistakes to avoid
Even a well-built chart can mislead if a few things are off. Here are some of the common mistakes to avoid:
Including too many data series: Charts with more than 4 or 5 data series can get hard to read fast. I've found that breaking a busy chart into multiple focused visuals communicates the story far more clearly than cramming everything into one.
Skipping axis labels: A chart without axis labels forces readers to guess what they're looking at. Always label your axes, especially when your units aren't obvious from the data.
Using 3D charts: 3D formatting can make it genuinely difficult to read exact values and compare data points accurately. I avoid them for business data and stick to flat chart styles.
Forgetting to update charts when your data changes: If your chart isn't linked to a dynamic data range, it won't update automatically when you add new rows. Check that your chart range covers all current and future data.
Using pie charts with too many segments: Once you go past around 6 to 8 segments, slices often become too small to read clearly. A bar chart will usually communicate the same information more cleanly, and I switch once I hit that range.
Analyze your data and build your charts in one place
Learning how to create charts in Excel is a solid skill, but if data prep keeps eating the hours you wanted to spend on analysis, Julius takes a different route.
Julius is an AI-powered data analysis tool. You ask questions in plain English and it analyzes your data, then builds the charts and visuals to match, no formulas required.
Here’s how Julius helps:
Data search: Julius can search the web for public datasets or pull structured financial data for 17,000+ companies via its Financial Datasets integration, so you can start from a question rather than an upload.
Direct connections: Link databases like PostgreSQL, Snowflake, and BigQuery, or integrate with Google Ads and other business tools. You can also upload CSV or Excel files. Your analysis can reflect live data, so you’re less likely to rely on outdated spreadsheets.
Built-in visualization: Ask a question and Julius returns the analysis with histograms, box plots, and bar charts on the spot, so you don't jump into another tool to build them.
One-click sharing: Turn an analysis into a PDF report you can share without extra formatting.
Ready to skip the spreadsheet and go straight to the insight? Try Julius for free today.
Frequently asked questions
What is the fastest way to create a chart in Excel?
The fastest way is to select your data and press Alt + F1 on Windows or Fn + Option + F1 on Mac, which inserts a default chart in one keystroke. You can change the chart type afterward from the Chart Design tab.
How many data series can an Excel chart handle?
Excel can technically handle hundreds of data series in a single chart, but charts with more than 4 or 5 series quickly become hard to read, so it’s better to simplify or split them. If you're working with a lot of series, consider summarizing your data or splitting it across multiple charts before visualizing it.
Can I create a chart from multiple sheets in Excel?
Yes, you can create a chart from multiple sheets by adding series that reference ranges on other sheets, as long as the data structure is consistent across those ranges. This works best when the data structures across sheets are consistent.
What's the difference between a chart and a graph in Excel?
A chart and a graph refer to the same thing in Excel. In Excel, Microsoft uses chart as the official term for data visuals, but many people casually say graph to mean the same thing in everyday use. For deeper data analysis beyond charts, Excel also supports PivotTables, Power Query, and formula-based modeling.
Are there AI tools that can build Excel charts automatically?
Yes, several AI tools for Excel can generate charts and analysis automatically from your spreadsheet data, reducing the manual steps involved in selecting ranges and formatting visuals.
