What You’ll Learn
- ✓How to set up data correctly before creating a chart
- ✓How to choose the right chart type for your data
- ✓How to insert and customize a chart using the Excel ribbon
- ✓How to add titles, labels, and chart elements
- ✓The most common beginner mistakes — and how to avoid them
Basic charts in Excel might just be the skill that transforms how people see your work — and no, that is not an exaggeration.
Picture this. You stay late pulling together a month’s worth of sales data for your manager. You paste it into an email — rows and rows of neatly formatted numbers. You are proud of it. Your manager opens it, scrolls for three seconds, and replies: “Can you just summarize this visually?” Sound familiar? You’ve probably seen this happen, or lived it yourself. The frustrating part is that the data was all there. It just wasn’t readable.
That is exactly the problem basic charts in Excel solve. They take your data and translate it into something the human brain actually wants to process — not a wall of numbers, but a shape, a bar, a slice, a line going up. This Excel chart tutorial for beginners covers everything: how to set up your data, how to pick the right chart, how to insert it, customize it, and make it look like something you are proud to share.
Why Visualizing Data Matters Even for Beginners
What a Chart Actually Does for Your Data
Here’s the thing about numbers in a spreadsheet: your brain is not naturally good at comparing them quickly. You can read that January sales were 4,200 and February was 5,800 — but it takes a moment to process that difference. Now imagine two bars, one noticeably taller than the other. You get it before your brain even forms a full thought.
That is not a trick — that is just how human perception works. We are wired to read shapes and heights far faster than we read digits. A chart does not add anything new to your data. It presents the same information in a format your brain prefers.
When you learn basic charts in Excel, you are not just ticking a software skill off a list. You are learning to communicate data clearly — and that matters whether you are a student, an employee, or a business owner.
When You Should and Should Not Use a Chart
Charts are the right tool when you are comparing values, showing how something changes over time, or breaking down how parts contribute to a whole. If the story in your data would take a paragraph to explain, a chart tells it in a second.
But charts are not always the answer. If you only have two or three data points, a chart can make things feel overengineered. If your reader needs exact figures to make a financial decision, a table is better. A quick test: if you would need to talk someone through the numbers verbally, the data probably wants to be a chart.
How to Create Basic Charts in Excel — Step by Step
Let us walk through this from a blank spreadsheet to a finished chart. No assumptions. No steps skipped.
Step-by-Step: Insert Your First Chart
Step 1 — Set Up Your Data the Right Way
Trust me on this — data setup is the step that trips up more beginners than any other. Here is what clean chart data looks like:
- Row 1 contains column headers (e.g. Month, Sales, Expenses) — not data values
- Each column represents one category or data series
- No blank rows or columns in the middle of your range
- Every row below the headers is a complete record
Need help cleaning up your spreadsheet first? Revisit Lesson 3: Formatting Cells on XplorExcel.com.
Step 2 — Select Your Data Range
Click the top-left cell of your data (usually your first header), then drag to the bottom-right cell. You will see a blue highlight covering everything. Always include the header row — Excel uses it to label your axes and legend automatically.
Step 3 — Insert a Chart Using the Ribbon
With your data highlighted, click the Insert tab at the top of the screen. Look for the Charts group. Click directly on a chart type icon if you know which one you want, or click Recommended Charts to let Excel suggest options.
Step 4 — Use Recommended Charts (The Beginner-Friendly Option)
Click Recommended Charts and a dialog box opens with suggestions suited to your data. A live preview appears on the right. Browse, click to preview, and when you find the right one — click OK. Your chart appears on the spreadsheet instantly as a floating object, ready to move and customize.
Choosing the Right Chart Type — Quick Decision Guide
Here is where most Excel chart tutorials for beginners leave you stranded. Ask yourself these three questions before you click anything:
- Am I comparing separate items or categories?
- Am I showing how a value changes over time?
- Am I showing how parts add up to one total?
Your answers will almost always lead to one of four chart types.
Excel Column Chart — Best for Comparing Categories Over Time
The column chart is the dependable all-rounder. Vertical bars where height equals value — taller bar, bigger number. Simple, clean, universally understood. Use it when comparing values across time-based categories like monthly revenue or quarterly scores. It is the chart type Excel recommends most often for a reason.
Excel Bar Chart — Best for Comparing Items Side by Side
An Excel bar chart is a column chart rotated ninety degrees — bars run horizontally. Use it when category labels are long, or when you are ranking many items and want the longest bar to stand out clearly. Think product comparisons, department performance, or survey rankings.
Excel Pie Chart — Best for Showing Parts of a Whole
The Excel pie chart divides a circle into slices — each slice represents one category’s share of the total. Perfect for answering: “what percentage of the whole does this represent?” One rule to remember: pie charts only work well with five or fewer slices. More than that and your chart becomes an unreadable color wheel. Switch to a bar chart instead.
Line Chart — Best for Trends Over Time
A line chart connects data points with a continuous line, making rises and drops immediately obvious. Use it when the movement between points matters as much as the points themselves — monthly website traffic, temperature over a year, or stock prices over a week.
Understanding Chart Elements
When Excel generates your chart, it adds several components automatically. Here is what each one does and why it matters.
Chart Title
The chart title sits at the top. Without a clear title, your reader’s first question is: “what am I looking at?” Always replace the default with something descriptive and short — something like Monthly Revenue Jan–Jun tells your reader everything in under a second.
Axes and Axis Labels
Most charts have two axes. The horizontal X-axis usually shows categories (months, products, names). The vertical Y-axis shows values (amounts, percentages). Axis labels tell your reader what those categories and values represent. Without them, a chart is just shapes.
Legend
The legend is the color key that appears beside or below the chart. It tells your reader which color represents which data series. One data series? You may not need it. Multiple series? Essential.
Data Labels
Data labels show the actual number on each bar, slice, or line point. They are optional, but useful when your reader needs precise values. To add them, right-click on any bar or slice and select Add Data Labels.
Customizing Your Chart in Excel
A freshly created chart from Excel looks functional but plain. A few small changes make a significant difference.
Changing Chart Style and Colors
Click on your chart to select it. A Chart Design tab appears in the ribbon — it only shows up when the chart is selected. In that tab, hover over Chart Styles to preview, then click to apply. For colors, click Change Colors at the top left of the Chart Design tab. Stick to one or two colors — a chart with six different colors is harder to read, not easier.
Moving and Resizing the Chart
Click once on the chart to select it. Handles appear around the edges. Drag a corner handle to resize; drag the body to move it. To place the chart on its own separate sheet, right-click the chart, select Move Chart, then choose New Sheet.
Editing the Chart Title Directly
Click once on the chart title to select it, then click a second time to enter edit mode. Type your new title and click anywhere outside the chart to confirm.
Keyboard Shortcuts — Chart Essentials
Alt + F1 → Insert chart on current sheet (default type)
F11 → Insert chart on a new sheet
Ctrl + Click → Select non-contiguous data ranges
Right-click chart → Select Data / Change Chart Type
Real-World Examples of Basic Charts in Excel
Example 1 — Monthly Expense Tracker (Column Chart)
Say you are tracking six months of spending across four categories: rent, food, transport, and entertainment. A column chart lets you see at a glance which months you overspent and which categories are creeping up over time. That kind of pattern recognition would take several minutes of squinting at a table. A column chart shows it in one glance.
Example 2 — Quarterly Sales Comparison (Bar Chart)
You run a small online business and want to compare how three products performed across four quarters. A bar chart works beautifully because product names can be long, and horizontal bars give them room. You can put this in a presentation and your audience will understand the results without you needing to explain a single number.
If you have been using Excel formulas to calculate totals and quarterly averages, now is the time to put that data to work visually. Head back to Lesson 5: Excel Formulas for Beginners at XplorExcel.com if you want a refresher before building this chart.
Example 3 — Survey Results Summary (Pie Chart)
You are a teacher who has asked thirty students which study method they prefer across five options. A pie chart instantly makes the most popular method obvious and shows how preferences are distributed. Put it in a staff meeting or parent presentation and everyone gets it immediately — no spreadsheet required.
💡 Pro Tip
When selecting your data range before inserting a chart, you do not have to select one continuous block. Hold Ctrl on your keyboard and click to select non-contiguous columns or rows. For example, to chart Column A and Column C while skipping Column B, hold Ctrl while clicking each column separately. Excel treats them as one combined selection and builds your chart from both — saving you a lot of unnecessary spreadsheet rearranging.
Common Mistakes to Avoid
⚠️ Common Mistakes
- Not including headers in your selection — Excel will label axes as “Series 1” and “Category 1”. Always include the header row.
- Accidentally including blank columns or rows — a hidden blank column inside your range adds a phantom data series. Check your selection carefully.
- Using a pie chart for too many slices — more than five slices becomes unreadable. Switch to a bar or column chart instead.
- Leaving the default chart title — “Chart Title” tells your reader nothing. Always replace it with something specific and descriptive.
- Not knowing the chart updates automatically — when you change a value in your spreadsheet, the chart updates on its own. If it is not updating, right-click the chart and select Select Data to check the range.
Frequently Asked Questions
What is the easiest chart to create in Excel?
The column chart is the most beginner-friendly option. It is what Excel recommends most often for basic comparisons, the labels are easy to read, and almost every audience knows how to interpret it. If you are creating your very first Excel chart, start here.
How do I change chart data after creating it?
Right-click anywhere on the chart and select Select Data. A dialog box opens showing you the current data range and the series Excel is plotting. You can edit the range, add new data series, or remove existing ones. Click OK and your chart updates immediately.
What is the difference between a bar chart and a column chart in Excel?
Only the orientation is different. Column charts are vertical and work well for time-based comparisons. Bar charts are horizontal and work better when you have many categories or long labels. The data, the logic, and the way you create them in Excel are identical.
🧪 Try It Yourself
Here is a short exercise to put everything into practice:
- Open a blank Excel spreadsheet.
- In cell A1 type Month, in B1 type Revenue, and in C1 type Expenses.
- Fill in six rows of data beneath the headers for January through June. Use any numbers you like.
- Select the full data range including your headers.
- Click the Insert tab and select Recommended Charts.
- Choose a column chart and click OK.
- Click the chart title and rename it to My Business Overview.
- Open the Chart Design tab and apply a different chart style.
- Right-click one of the bars and add data labels.
- Click and drag the chart so it sits below your data table.
When your chart has a clear title, clean colors, visible data labels, and sits neatly below your data — you are done. You just built your first professional-looking chart in Excel from scratch.
📚 External Resources
Microsoft Support — For the official step-by-step walkthrough from the Excel product team, visit Create a chart from start to finish. Kept up to date with current Excel versions across all platforms.
Exceljet — For plain-language explanations of every Excel chart type with practical guidance on when to use each one, see the Excel Charts reference on Exceljet. One of the best free resources available for chart selection decisions.
What’s Next on Your Excel Journey?
You have covered a lot of ground in this lesson. You know how to set up data for charting, how to choose between the most common chart types, how to insert and customize a chart, and how to avoid the mistakes that catch most beginners off guard.
Basic charts in Excel are the foundation of data communication in Excel, and you now have a solid one to build on. When you are ready to go further — combination charts, secondary axes, dynamic charts — head to Lesson 10: Advanced Charts at XplorExcel.com.