Learn how to build bar, line, and pie charts in Excel from scratch — and understand when to use each one. This hands-on lesson takes you from raw data to polished, professional visualizations using realistic business scenarios.

A table of numbers tells a story, but it rarely tells it well. Imagine you're presenting quarterly sales results to your manager — you've got twelve months of revenue figures, broken down by three product lines, all neatly entered in a spreadsheet. You could read them off row by row, but the moment you drop those numbers into a well-constructed chart, patterns that were invisible in the data suddenly become obvious: one product line is declining, another is surging, and Q3 is consistently your strongest quarter. Charts don't just make data look better — they make data mean something.
In this lesson, we're going to build real competence with Excel's charting system from the ground up. You'll learn not just how to click "Insert Chart," but why certain chart types work for certain data, what makes a chart effective versus misleading, and how to customize every element to communicate clearly. We'll work through bar charts, line charts, and pie charts — the three workhorses of data visualization — using a realistic business scenario you'll recognize from your own work.
By the end of this lesson, you'll be able to look at any dataset and confidently choose the right chart type, build it quickly, and polish it to a professional standard.
What you'll learn:
This lesson assumes you're comfortable navigating Excel's interface, entering data into cells, and working with basic spreadsheet structure. If you need to brush up on any of those fundamentals, start with Entering and Managing Data in Excel: Best Practices for Clean, Consistent Spreadsheets before continuing here. You should also be familiar with selecting cell ranges — if terms like "A1:D13" look unfamiliar, that foundation will be worth building first.
Before we touch a single menu, let's establish a mental model that will make everything else click.
A chart in Excel is a visual representation of a data range. Excel reads your data, identifies what it thinks are categories (usually text labels) and values (usually numbers), and plots them according to the chart type you choose. The connection between your data and the chart is live — if you change a number in your spreadsheet, the chart updates automatically. This is not just convenient; it means your charts are always accurate as long as your data is.
Excel organizes chart data around two concepts:
When you select a range that includes both labels and numbers, Excel makes an educated guess about which is which. It's usually right, but knowing this lets you correct it when it isn't.
Key insight
The quality of your chart starts with the quality of your data layout. Data that's organized in clean rows and columns with clear headers will almost always produce a correct chart on the first try. Messy or merged data produces confusion. This is why data structure habits matter long before you ever open the Insert tab.
Let's work with a realistic scenario throughout this lesson. You're a data analyst at a regional coffee company called Northbrook Roasters. You have sales data for three product lines — Whole Bean, Ground Coffee, and Espresso Pods — across six months of the year. Enter this into a blank spreadsheet starting at cell A1:
Month Whole Bean Ground Coffee Espresso Pods
January 18400 22100 9800
February 17200 21300 10400
March 19800 23500 11200
April 21500 24800 13100
May 23200 26400 15300
June 24800 27900 16800
This is clean, well-structured data: one header row, text labels in the first column, numeric values in columns B through D. Each row is a category (a month), each column after the first is a series (a product line). This layout is the foundation for every chart we'll build.
Tip
Always include your column headers in the selection when creating a chart. Excel uses them as series names in the legend and axis labels. If you forget to include them, you'll get "Series 1," "Series 2," and "Series 3" instead of meaningful labels.
Bar charts — which Excel calls "Column charts" when the bars run vertically, and "Bar charts" when they run horizontally — are ideal for comparing values across distinct categories. Our monthly sales comparison is a perfect candidate.
Click on cell A1 and drag to D7, selecting the entire table including headers and all six months. Your selection should cover 7 rows and 4 columns.
With your data selected, navigate to the Insert tab on the Ribbon. In the Charts group, you'll see several icons. Click on the Insert Column or Bar Chart button — it shows a small icon of vertical bars. A dropdown gallery appears showing several chart subtypes. Click Clustered Column (the first option in the top-left of the 2-D Column section).
Excel immediately places a chart on your worksheet. You should see six groups of three bars — one group per month, one bar per product line, with a color-coded legend at the bottom. Take a moment to appreciate what just happened: six rows of numbers became a visual story showing that all three product lines are growing over the six-month period, and that Ground Coffee consistently outsells the others.
Your chart has several distinct elements, each of which you can click and customize independently:
Renaming the title: Double-click the "Chart Title" text box. The cursor appears inside the text. Select all the existing text and type: Northbrook Roasters — Monthly Sales by Product Line. Click anywhere outside the chart to deselect.
Adjusting the vertical axis: The Y-axis currently starts at zero, which is correct for a bar chart (always start at zero for bar charts — more on this in the mistakes section). But the numbers are displayed as raw integers like 18400. Right-click on the vertical axis numbers and choose Format Axis. In the Format Axis pane that appears on the right, expand Number and change the format to Number with zero decimal places and a thousands separator. The axis now reads 18,400 instead of 18400 — much cleaner.
Adding data labels: Sometimes you want the exact value visible on each bar. Right-click on one of the bar series, choose Add Data Labels, then Add Data Labels again. The values appear on each bar. If this makes the chart look crowded, you can remove them by right-clicking the labels and choosing Delete.
Warning
Avoid stacking too many customizations onto a chart for a general audience. Data labels, gridlines, a legend, and axis titles all at once can create visual noise. Add only what's necessary to answer the question the chart is meant to address.
Moving and resizing: Click on the chart's edge (not inside it) to select the entire chart object. You can drag it to any position on the sheet, or drag the corner handles to resize it. To move a chart to its own dedicated worksheet — which is useful for presentations — right-click the chart, choose Move Chart, and select New sheet.
While bar charts compare values across categories, line charts are purpose-built for showing change over time. They draw the eye along a continuous path, making trends, acceleration, and seasonality instantly visible. Our six-month sales data has a clear time dimension, which makes it a good candidate for a line chart too.
A bar chart says "here are the values in each period." A line chart says "here's how the value is moving." The slope of a line is information — it tells you whether growth is accelerating, slowing down, or reversing. For trend analysis, line charts are almost always the superior choice over bars.
Click on a blank area of your sheet first, then reselect your data range A1:D7. Go to Insert tab → Charts group → click the Insert Line or Area Chart button (it shows a small line icon). Choose Line with Markers — this adds a dot at each data point, which is helpful when you have a small number of periods.
Your chart now shows three lines, one per product line, rising from left to right. Notice how immediately obvious it is that Espresso Pods, while the smallest category, is growing at a steeper angle than the others. This insight was present in the bar chart too, but it's dramatically more visible here. The slope tells the story.
Add a title: Double-click the title area and type Northbrook Roasters — Six-Month Sales Trend.
Format individual lines: Click on the Espresso Pods line to select that series. Right-click and choose Format Data Series. In the pane that appears, you can change the line color, thickness (called "Width"), and marker style. Making your fastest-growing line a bolder, thicker style draws attention to it appropriately.
Add axis titles: Click anywhere on the chart to activate it, then look for the Chart Elements button — a small plus (+) symbol that appears just outside the top-right corner of the chart. Click it to see a checklist of chart elements. Check Axis Titles. Two placeholder text boxes appear: one on the left side (for the Y-axis) and one at the bottom (for the X-axis). Double-click each and type appropriate labels — "Monthly Revenue ($)" for the Y-axis and "Month" for the X-axis.
Tip
Axis titles are more important than many people realize. A chart without axis titles forces the reader to guess what the units are. When you're building charts for others — not just yourself — always label your axes.
The resulting chart now gives any reader everything they need: a clear title, labeled axes, a color-coded legend, and three lines that make the growth trajectory of each product line undeniable.
Pie charts do one thing well: they show how a single whole is divided into parts. They answer the question "what percentage of the total does each category represent?" They are genuinely useful for this — and genuinely terrible for almost everything else.
For our Northbrook Roasters scenario, a natural use of a pie chart would be to show the total revenue contribution of each product line across the entire six-month period.
A pie chart needs exactly two columns: a list of category names and a list of corresponding values. We need to calculate each product line's total. In a blank area of your sheet — let's say cells F1:G4 — create this summary:
Product Line Total Revenue
Whole Bean =SUM(B2:B7)
Ground Coffee =SUM(C2:C7)
Espresso Pods =SUM(D2:D7)
If you need a refresher on the SUM function and how it aggregates ranges like this, the lesson on essential Excel functions covers it thoroughly. After entering the formulas, your G column should show 124900, 146000, and 76600 respectively.
Select cells F1:G4 (both columns including headers). Go to Insert tab → Charts group → click Insert Pie or Doughnut Chart → choose Pie (the first 2-D option).
A circular chart appears with three slices. Ground Coffee takes the largest slice, Whole Bean is in the middle, and Espresso Pods is the smallest — which matches our data exactly.
Add percentage labels: Right-click anywhere on the pie and choose Add Data Labels. By default, this shows the raw revenue numbers. Right-click the labels again and choose Format Data Labels. In the pane that appears, uncheck Value and check Percentage. The labels now show "42%," "36%," and "22%" — which is exactly what a pie chart is meant to communicate.
Show category names on slices: In the same Format Data Labels pane, also check Category Name. Each slice now shows both the product name and its percentage, making the legend redundant. You can hide the legend by clicking it and pressing Delete.
Explode a slice: Sometimes you want to call attention to a particular slice — for example, Espresso Pods, your fastest-growing category. Click the pie once to select all slices, then click a second time to select only the Espresso Pods slice. Drag it slightly away from the center. This "exploded" slice technique is a classic way to highlight a segment.
Key insight
Pie charts should almost never have more than five slices. With more than five categories, slices become too thin to read accurately, and the chart turns into a visual puzzle. If you have more categories, consider a bar chart with a "Other" aggregate category instead.
Understanding why to use each chart type is as important as knowing how to build them. Here's a practical decision framework:
Use a bar/column chart when:
Use a line chart when:
Use a pie chart when:
Warning
A very common mistake is using a pie chart to compare values over time — for example, one pie per month showing the revenue split. This forces the reader to compare slices across six separate circles, which the human eye does very poorly. Use a stacked bar chart for this instead.
One of Excel's most powerful features is that charts stay connected to their source data. If Northbrook Roasters revises their January Whole Bean figure from 18,400 to 19,100, you simply update cell B2 and every chart that uses that data refreshes automatically.
You can also expand a chart's data range after the fact. Right-click your chart and choose Select Data. The Select Data Source dialog shows you the current data range. Click the range reference at the top and manually edit it, or click the small range selector icon and drag to select a new range. This is how you'd add a seventh month (July) to your charts after the fact.
If you're building charts from data that changes regularly — such as a monthly report — consider formatting your source data as a formal Excel Table first (Insert tab → Table). Tables expand automatically when you add new rows, and charts built from Table ranges often update their scope automatically too. The PivotTables from Scratch lesson explores how structured tables power more advanced reporting tools, and many of those same principles apply here.
Apply what you've learned with this complete exercise. It should take 20–30 minutes.
Scenario: You're a business analyst at a software company. You have quarterly subscription data for three plans — Basic, Professional, and Enterprise — across four quarters.
Step 1 — Enter the data. In a new worksheet, enter:
Quarter Basic Professional Enterprise
Q1 3200 1850 420
Q2 3450 2100 510
Q3 3800 2380 670
Q4 4100 2650 890
Step 2 — Build a clustered column chart. Select A1:D5 and insert a Clustered Column chart. Add a descriptive title, label both axes, and format the vertical axis numbers with comma separators.
Step 3 — Build a line chart. Create a second chart from the same data as a Line with Markers chart. Notice how the growth trend of the Enterprise tier is visibly steeper proportionally than the others even though its absolute numbers are smaller. Add a chart title that reflects this insight, like "Enterprise Subscriptions Growing Fastest by Rate."
Step 4 — Build a pie chart. Calculate the total subscriptions per plan across all four quarters (use SUM formulas). Create a pie chart from those totals. Add percentage labels and category names. Remove the legend since the labels make it redundant.
Step 5 — Reflect. Look at all three charts and ask yourself: which one would you use in a presentation about growth potential, and why?
"My chart has the data backward — months are series instead of categories." This happens when Excel misreads which dimension is the series and which is the category. Right-click the chart, choose Select Data, and click Switch Row/Column. This flips the orientation and usually fixes it immediately.
"My line chart connects my categories with lines, but they're not in time order." Excel plots data in the order it appears in your spreadsheet. If your months or dates aren't in chronological order in your source data, sort the source data first. Charts don't re-sort data — they plot it as-given.
"My pie chart has tiny slivers that are impossible to read." You have too many categories. Aggregate the smallest ones into an "Other" category by summing them, then rebuild the chart from the simplified dataset.
"The bars on my bar chart don't start at zero." Actually, in Excel's default settings, bars do start at zero. But if someone has manually changed the minimum axis value (a common manipulation), your bars will be visually misleading. Right-click the vertical axis, choose Format Axis, and under Bounds, reset the Minimum to 0.
"My chart title disappeared." You may have accidentally deleted it. Click the chart to select it, then click the Chart Elements (+) button in the top-right corner and re-check Chart Title.
Note
When you're working with charts embedded in a worksheet, clicking on a chart and clicking outside a chart behave very differently. A single click on the chart border selects the entire chart object (you can move and resize it). A single click inside the chart activates it for editing. Double-clicking on specific elements like titles or axes opens their format panes. If formatting options seem grayed out, check whether you've actually activated the chart by clicking inside it.
You've now built all three foundational chart types in Excel and, more importantly, you understand why each one exists. Bar charts compare magnitudes. Line charts reveal trends. Pie charts show proportions. Every advanced chart in Excel is an extension or combination of these core ideas.
Here's what you accomplished in this lesson:
Where to go next depends on your goals. If you want to make your charts interactive — allowing viewers to filter and explore data themselves — the natural next step is learning about PivotTables and the powerful visual tools that connect to them. The lesson on Building Interactive Dashboards with Pivot Tables will show you how to combine multiple charts and slicers into a single, cohesive reporting view.
If you want to go deeper on chart design and dynamics — things like sparklines embedded in cells, timeline slicers, and charts that update automatically based on user selections — the Building Dynamic Charts and Dashboards in Excel lesson is your direct next step in this learning path.
And if you want to enhance your underlying data with better formatting before it reaches your charts, exploring conditional formatting techniques will help you build source data that's both accurate and visually clear.
Charts are where data becomes communication. The skills you've built here are the foundation of every dashboard, every report, and every presentation you'll produce as a data professional.