How to Create a Chart in Excel
Create useful Excel charts by choosing the right source table, chart type, labels, formatting, and review context.
An Excel chart turns a table into a visual answer. The chart type matters less than the question it is supposed to answer: trend, comparison, composition, ranking, or progress.
Start with clean data, choose the simplest chart that answers the review question, then format it so the reader can understand it without decoding the spreadsheet.
Step-by-step chart build
Step 1. Clean the source table
Use one header row, one record per row, and consistent labels. Remove blank rows inside the data range. If the source table is messy, the chart will be harder to maintain than the data itself.
Step 2. Choose the chart type
Use chart types based on the job:
| Question | Chart type |
|---|---|
| How is this changing over time? | Line chart |
| Which category is largest? | Bar or column chart |
| How do parts compare to the whole? | Stacked bar or limited pie/donut chart |
| How does progress compare to target? | Bar chart with target marker |
| What is the schedule? | Gantt chart |
For most business workbooks, bar charts and line charts cover more needs than decorative chart types.
Step 3. Select the range and insert the chart
Highlight the labels and values, then insert the chart. If the chart looks wrong, check whether Excel guessed the row and column orientation correctly. Use Switch Row/Column when the categories and series are flipped.
Step 4. Add useful labels
Use a direct chart title like Pipeline by Stage or Monthly Expenses by Category. Add axis labels only when the units are not obvious. Avoid repeating every value as a data label unless the exact number matters.
Step 5. Format for review
Remove visual clutter before adding decoration. Light gridlines, readable labels, and consistent number formats matter more than gradients, shadows, or 3D effects.
TIP
Useful formulas before charting
Charts often need summary values before they are useful. For example, count tasks by status:
=COUNTIF(StatusRange, "Blocked")Or sum expenses by category:
=SUMIF(CategoryRange, "Software", AmountRange)These formulas create chart-ready summary tables from raw operating data.
Where charts fit in real templates
Charts work best when they sit on top of a useful data model. A project tracker template can feed charts for blocked tasks by owner or workstream. A sales pipeline template can feed charts for pipeline by stage. A small business budget can feed monthly revenue, expense, and margin views.
The Griddy way
Manual charting gets slow when the source data needs cleanup, formulas, labels, and layout changes before the chart is ready.
"Create charts from this project tracker showing tasks by status, blocked work by owner, and due dates by week."
Griddy can build the summary tables, choose practical chart types, and place the charts into a dashboard-style view.
Skip the manual work
Describe it. Griddy does it.
Instead of writing this formula yourself, just tell Griddy what you need in plain English. Works in Excel and Google Sheets.
Use this on real templates
Build charts from structured templates
Charts become more reliable when the source sheet already has clean columns for owners, statuses, dates, amounts, and categories.
Project Tracker
Track tasks, owners, priorities, due dates, and blockers in one delivery board. Group work by stream, review progress, and keep next steps visible.
Open templateProject ManagementGantt Chart
Use this free Gantt chart template to plan project phases, owners, milestones, dependencies, and weekly timelines in Excel, Google Sheets, or Griddy.
Open templateSalesSales Pipeline
Track deals by stage, owner, value, and next move in one lightweight pipeline sheet. Keep close dates, weighted forecast, and rep follow-ups visible without needing a full CRM.
Open templateFinanceSmall Business Budget
Plan revenue, direct costs, overhead, and EBITDA in one compact operating budget. Keep H1 totals, margin, and owner notes visible without building a giant finance model.
Open template