Create a pivot chart without Excel from the traffic sample
A pivot chart without Excel is a summarized chart made where the spreadsheet happens to be open: in the browser. You do not need a desktop license, a ribbon, or a PivotChart field pane. Upload a CSV or XLSX file, choose the row, the optional column, the value, and Sum, Average, or Count. This page starts on the Chart tab with the traffic sample already grouped.
That sample has 8 rows and 3 columns: Month, Channel, and Sessions. Each month appears twice, once for Organic and once for Paid. The dates are 2026-01-01, 2026-02-01, 2026-03-01, and 2026-04-01. The date control is set to Month, so the axis labels are 2026-01, 2026-02, 2026-03, and 2026-04 rather than four identical day numbers. Channel stays as the series field. Sum of Sessions draws two lines. Organic moves 4,200, 4,550, 5,100, 4,980. Paid moves 1,800, 2,100, 1,960, 2,400.
The table behind that chart is the part worth checking before you share the picture. Monthly totals are 6,000, 6,650, 7,060, and 7,380. The grand total is 27,090. Organic is 18,830, about 69.5 percent of sessions. Paid is 8,260. March Organic is the highest single cell at 5,100. April is the highest month at 7,380, which is 320 sessions above March. This pivot chart without Excel does not plot that 320-session difference for you. Read it off the totals, or add the subtraction in a spreadsheet after you export the matrix.
What you skip from the Excel PivotChart steps
Create a PivotChart tells Excel users to select a cell in a table, choose Insert, then PivotChart, pick a location, and then tick fields. That produces a chart tied to a PivotTable. Change the fields and both objects update. Refresh the PivotTable after the source grows and the chart follows. A pivot chart without Excel on this page does not create that pair of objects. It calculates one aggregation in memory and paints one Chart.js view.
The practical difference shows up when the source changes. Here, you upload the new file or paste the new extract and rebuild the same field choices. You do not press Refresh on a PivotCache. That is a limitation, and it is also why the page can run on a machine where Excel is not installed. The export options match that model: PNG for the picture, CSV for the aggregated grid, and XLSX for the source rows plus the calculated grid and a static chart image. None of those files keeps refreshing after you leave the page.
Switch samples when the question is not a time series
The sales sample is the comparison chart. It has 12 rows. Put Region on the axis, Category in the series, and Sum of Sales in the values. West leads at 404,815. Technology leads the columns at 528,627. The grand total is 1,194,082. A bar chart matches that question because the regions are names, not dates. The line option still draws, but it implies an order the region names do not have. Leave the chart type on Bar for that sample.
The survey sample is smaller: 9 rows, 396 responses, three teams and three topics. Support is 191, Success is 130, and Sales is 75. It is useful when you want to see Count versus Sum. Sum of Responses totals 396. Count of Responses totals 9. The chart axis on this page is labeled in thousands, so a few hundred responses look cramped. Use the survey sample to learn the field controls, then judge the teams from the pivot table. Use traffic or sales when you want a chart whose scale matches the axis.
Chart intent has two settings, Compare and Share. Compare keeps a bar or line. Share can switch an automatic chart to pie when there is a single value column and between 2 and 12 groups. The traffic sample has two series, Organic and Paid, so it stays a line even if you press Share. Clear the Channel field, leave Month as the only dimension, and a pie of four monthly totals becomes available. Four slices that add to 27,090 are readable. A pie of many product names is not. The chart type guide covers that choice in more detail.
Prepare the file that feeds the chart
The chart is only as specific as the rows you upload. Use one header row. Keep one record on each following row. Do not include a title, a blank spacer, or a total line that already sums the rows. A total line is added again by Sum, so the grand total would be too large. For the traffic shape, that mistake would mean an extra row labeled Total whose Sessions cell is 27,090, and the chart would plot that label beside the months.
Dates need a shape the detector recognizes. YYYY-MM-DD works. A month name plus a four-digit year, such as Jan 2026, works. A day, a month name, and a year, such as 15 Jan 2026, works. A locale string such as 4/1/2026 is not detected as a date, so the Month grouping list will not appear until you set the field type to Date yourself. After you override the type, choose Month, Quarter, Year, Week, or Day. The traffic file uses the first of each month so Month and Day labels do not disagree about which day the row represents.
Numbers can include commas. A currency symbol can be detected as currency. Percent signs are divided by 100. Text in the value column is skipped for Sum and Average. Count skips blank value cells and counts the rest. If the status says 0 rows can be used, the value field is the wrong column or the cells are labels. The traffic Sessions column is plain integers, so all 8 rows are usable.
Filters, limits, and the export you can hand to someone else
A filter changes both the chart and the table. On the traffic sample, filter Channel to Organic only. The line should keep four points: 4,200, 4,550, 5,100, and 4,980, totaling 18,830, and the status should read 4 of 8 rows. Filter to Paid only and the points are 1,800, 2,100, 1,960, and 2,400, totaling 8,260. If both filters are cleared, you are back to 8 of 8 and 27,090. The chart does not warn you that a filter is active beyond that row count, so read the count before you export.
Limits are 10 MB, 200 rows, 30 columns, and 6,000 cells. The traffic sample is 8 by 3. A year of daily rows with several channels can cross 200 rows; aggregate it to months in the source, or split the file, before uploading. Only the first worksheet of an XLSX file is read. CSV is often the easier extract when you are creating a pivot chart without Excel on a shared computer, because you can save the sheet as CSV from another program and skip the workbook entirely. The CSV to pivot chart guide covers header cleanup.
Export PNG from the Chart tab after the table totals match the source. The image is the chart canvas, not a vector file. Export CSV when a colleague needs the 4 by 2 session grid without the picture. Export XLSX when they need the 8 source rows and the summary in one workbook. Tell them the summary will not refresh inside Excel. For a refreshable chart, the Microsoft article above is the path that actually creates one, and it requires Excel.
Confirm the page stayed on your machine
Creating a pivot chart without Excel should not mean uploading the workbook to an account you do not control. This page has no sign-in. The sample buttons copy rows that shipped with the site, or, on the XLSX page, fetch the sample workbook file itself. Your own file is chosen through the file input and parsed in the tab. Watch the network panel while you select a local file: the selection should not create a POST of that file. Refreshing discards the parsed rows.
The first XLSX export can still cause a network request, because the Excel-writing code is loaded when that button is used. The response is a script chunk. The workbook bytes are built afterward in the browser and saved as pivot-chart-maker-export.xlsx. If you only need the PNG, you can skip that download. The PNG is produced from the chart already on the page.
Checked result
Sum of Sessions by month and channel in the 8-row traffic sample. Grand total is 27,090.
| Month | Organic | Paid | Total |
|---|---|---|---|
| 2026-01 | 4,200 | 1,800 | 6,000 |
| 2026-02 | 4,550 | 2,100 | 6,650 |
| 2026-03 | 5,100 | 1,960 | 7,060 |
| 2026-04 | 4,980 | 2,400 | 7,380 |
| Grand total | 18,830 | 8,260 | 27,090 |
Organic is 18,830 of 27,090 sessions, about 69.5 percent. April's total, 7,380, is 320 sessions above March's 7,060. Subtract the exported totals yourself; there is no period-over-period aggregation.
Source note
Excel's own steps are Insert, then PivotChart, as described in Create a PivotChart. Use that path when Excel is installed and you need a refreshable PivotChart. Use this page when you only have a browser and a CSV or XLSX file.
Questions about this page
Can I create a pivot chart online without Excel installed?
Yes. This page runs in a current browser. Upload a CSV or XLSX file, or load the traffic sample. You get a chart plus the summary table. Excel can stay uninstalled.
Which chart types can I create?
Bar, line, and pie. The traffic sample starts as a line because Month is a date. Sales starts as a bar. Pie fits a short, single-series share, such as one column of category totals, not a two-channel time series.
Is this the same object Excel creates?
No. Excel can store a PivotChart that refreshes from a PivotCache. This page draws the chart in the browser and can export a PNG plus the calculated numbers. The XLSX download does not contain a refreshable PivotChart.
What should I check before exporting the PNG?
Open the Pivot Table tab and confirm the totals. For the traffic sample, the four months are 6,000, 6,650, 7,060, and 7,380, and the grand total is 27,090. Then return to the Chart tab and export PNG.