Bar chart
Best for comparing categories, such as sales by region or orders by product. Sort values when you want the ranking to stand out.
01One header row
Use clear, unique names such as Region, Order Date, and Sales.
02One record per row
Keep every transaction or observation on its own row.
03A question to answer
For example: which region had the highest sales?
Start here
The simple pivot chart workflow
Think of the process as a sequence: source data becomes a summarized table, and the table becomes a chart.
- 1Prepare the source data
Remove merged cells, blank header rows, and subtotal rows. Make sure every column has a unique label and every amount is stored as a number.
- 2Choose the pivot fields
Select a field for rows, optionally another for columns, and a numeric value to calculate. For sales by region, use Region for rows and Sales as the value.
- 3Set the calculation
Use Sum for totals, Count for the number of records, or Average for a typical value. Apply filters when you need to focus on a period or segment.
- 4Check the table, then chart it
Verify the pivot totals before selecting a visual. A correct pivot table is the foundation of a trustworthy chart.
Make it readable
Choose the chart that fits the comparison
Start with the analytical question, not the prettiest chart. The right choice makes the result easier to interpret at a glance.
Line chart
Best for change over time. Group dates by month, quarter, or year so the trend is meaningful and the line stays readable.
Pie chart
Best only for a small number of parts of a whole. Use it when the total matters and there are few enough categories to label clearly.
Useful rule: if the audience needs to compare similar values precisely, use a bar chart rather than a pie chart.
Common questions
Pivot chart FAQ
These answers cover the setup details that most often affect the accuracy and clarity of a pivot chart.
What data do I need for a pivot chart?
Use a tidy table with one header row, one record per row, at least one field to group by, and one value to calculate. A simple sales file might contain Region, Category, Order Date, and Sales.
Can I create a pivot chart without Excel?
Yes. You can use a browser-based tool to upload CSV or XLSX data, configure row, column, and value fields, and export the resulting chart or summary table.
Why does my pivot chart look wrong?
Check the pivot table first. Common causes are blank or repeated headers, values stored as text, dates that were not recognized as dates, and source data that includes totals or subtotal rows.
What is the difference between a pivot table and a pivot chart?
A pivot table is the summarized grid of numbers. A pivot chart is the visual representation of that summary. Use the table to verify exact values and the chart to communicate the pattern.
How do I export a pivot chart?
After reviewing the summary, export the chart as an image for slides or reports. Export the pivot table as CSV or XLSX when someone needs the underlying summarized values.