ARTICLE / 5 MIN READ
How to Create a Chart in Excel — A Beginner's Guide
FEBRUARY 26, 2026
Creating a chart in Excel sounds like it should be straightforward. And honestly? It mostly is — once you know which three steps actually matter and which menus to ignore.
Here’s the complete beginner’s guide.
Before You Start: Get Your Data in the Right Shape
Excel can only chart data it understands. That means your data needs to follow one simple rule: headers in the first row, data below them.
Good data layout:
| Month | Revenue | Expenses |
|---|---|---|
| Jan | 12000 | 8000 |
| Feb | 14000 | 8500 |
| Mar | 15500 | 9000 |
Bad data layout: numbers scattered around, merged cells, blank rows in the middle, totals mixed in with monthly rows. Fix those before you start charting or your chart will come out looking wrong.
Step 1 — Select Your Data
Click the first cell of your data (including the header row), then drag to select everything you want in the chart. If your columns aren’t next to each other, hold Ctrl and click each range separately.
A common mistake: selecting too much. If you have 20 columns but only want to chart 2 of them, only select those 2 — plus your label column.
Step 2 — Insert a Chart
With your data selected, go to the Insert tab in the ribbon, then look for the Charts group. You’ll see buttons for recommended chart types.
The fastest option: click Recommended Charts. Excel looks at your data and suggests the chart types that fit best. For most basic datasets, it’ll recommend a bar or column chart — which is usually exactly right.
If you already know what type you want, you can click directly into Column, Line, Pie, Bar, etc.
Click the chart you want and hit OK. The chart appears on your spreadsheet immediately.
Step 3 — Move and Resize It
The chart will land somewhere random on your sheet. Click and drag it to where you want it. Drag the corners to resize.
If you want the chart on its own separate tab (cleaner for sharing), right-click the chart → Move Chart → New Sheet.
Step 4 — Give It a Proper Title
Click directly on the “Chart Title” text at the top. Delete the placeholder text and type something descriptive — not “Chart 1.” Your reader shouldn’t have to guess what they’re looking at.
Good title: Monthly Revenue vs. Expenses — Q1 2026 Bad title: Chart Title
Step 5 — Quick Formatting Wins
You don’t need to spend an hour on this. Three quick changes make almost any chart look better:
- Delete the legend if you only have one data series — it’s just clutter
- Change the colors — click a bar or line, right-click → Format Data Series → pick a color that matches your brand or report
- Remove the border around the chart — right-click the chart area → Format Chart Area → No line
That’s it. You now have a clean, readable Excel chart.
Common Questions
My chart looks wrong — the axes are flipped. Excel sometimes guesses wrong about which direction to plot your data. Right-click the chart → Select Data → click Switch Row/Column to flip it.
I added new data but the chart didn’t update. Click the chart once. You’ll see colored boxes around the data it’s reading from. Drag those boxes to include your new rows.
How do I change the chart type after I’ve created it? Right-click anywhere on the chart → Change Chart Type → pick a new one. All your data and formatting stays intact.
What to Do When Charts Aren’t Enough
Charts in Excel are great for exploring your data. But if your goal is a polished, shareable dashboard — not just a chart sitting inside a spreadsheet — you’ll quickly run into the limitations of Excel’s layout system.
Tools like Sheetglow take your existing spreadsheet data and generate a clean visual dashboard automatically, without any of the manual formatting work.
Creating a chart in Excel takes about 2 minutes once you know the steps. The hard part isn’t making it — it’s making it look good.