Pivot Chart Maker

Worked example

Pivot Chart Example: Sales by Region and Category

Use this small retail sales dataset to build a pivot table and a clustered bar chart. The example keeps the setup simple while showing an analysis that is useful in a real report.

Download the example data

The CSV contains 12 sales records across four regions and three product categories. It is intentionally compact so you can inspect every source record before trusting the result.

Download the sales example CSV

Question answered

Which product category generated the most sales in each region? Create a pivot table with Region in Rows, Category in Columns, and Sales in Values using Sum. The resulting chart makes both the regional totals and category mix easy to compare.

Pivot Chart Maker showing the sales CSV, field settings, a bar chart, and pivot table totals by region and category.
Example setup: Region × Category with Sum of Sales. The chart and the table are generated from the same 12-record CSV.

How to read the result

Technology is the largest category in every region in this example. The West has the highest Technology sales, while the East has the largest overall total. Verify those conclusions in the pivot table before using the chart in a presentation.

Learn the method

How to create a pivot chart onlineCreate the same chart in ExcelTurn a CSV into a pivot chartPivot table vs. pivot chart