To make an interactive expense chart in Excel, build a PivotTable from your transactions, click inside it and choose PivotTable Analyze, then PivotChart. Add a Category slicer and a Date timeline from the same tab. Clicking a category or dragging across months then redraws the chart. Connect the same slicer to a second pivot and one click filters both.
Start from a Table, then add the pivot chart
Your transactions should sit in an Excel Table (click inside the data, press Ctrl+T) with a real Date column, a Category column and an Amount column. Insert a PivotTable from it, put Category in Rows and Amount in Values, then click inside the pivot and choose PivotTable Analyze, then PivotChart. A clustered column or bar chart suits category totals.
The grey buttons on the chart are field buttons. Right-click one and choose Hide All Field Buttons on Chart if you want a cleaner look for sharing. The chart is tied to the pivot, so you cannot drag a data range into it as you would with a normal chart.
How do I add a Category slicer?
Click inside the pivot, choose PivotTable Analyze, then Insert Slicer, and tick Category. A box of buttons appears. Click one to filter, hold Ctrl and click to pick several, and use the small filter-with-a-cross icon in the corner to clear. Drag the slicer beside the chart and use the Slicer tab to set the number of columns, so it does not run off the screen.
How do I add a date timeline?
Choose PivotTable Analyze, then Insert Timeline, and tick Date. The timeline works only on a field Excel recognises as dates, so text dates will not show up in the list. Use the drop-down at the top right of the timeline to switch between Days, Months, Quarters and Years, then drag across the bars to select a stretch such as April to September.
Can one slicer control several pivots?
Yes, but only pivots that share the same source data cache appear in the connection list. The simplest way to get that is to copy your first pivot, paste it elsewhere on the sheet, and change the fields in the copy. Then right-click the slicer, choose Report Connections, and tick every pivot it should control.
| Pivot | Rows | Values | Drives which chart |
|---|---|---|---|
| Pivot 1 | Category | Sum of Amount | Bar chart of category totals |
| Pivot 2 | Date grouped by month | Sum of Amount | Line chart of the monthly trend |
| Pivot 3 | Merchant | Sum of Amount | Top merchants list or chart |
Connect the Category slicer and the Date timeline to all three. Click Groceries and the bars, the trend and the merchant list all narrow to groceries together. That single clickable view is the whole point of the exercise.
Things that quietly go wrong
- New transactions do not appear until you choose Data, then Refresh All. Slicers only filter what the pivot already holds.
- A pivot chart resets some formatting when the layout changes. Set colours and axis text after you finish arranging the fields.
- Slicer buttons show every category in the source, including ones with no spending in the selected months. They simply appear greyed.
- Copied and pasted pivots can drift from each other if someone edits one filter by hand. Always filter through the slicer.
Before you share the file
Slicers and timelines are interactive only in Excel itself. A screenshot or a printed copy shows whatever was selected at that moment, so clear the slicers first if you want the full picture. If you send the workbook to a family member, remember the transaction rows travel with it, so consider whether you want to include the data sheet.
A quick checklist: Table made, pivots share one cache, slicer connected to each pivot, timeline set to Months, field buttons hidden, and a fresh Refresh All pressed before you save.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

