I have a problem with pivot table and chart.
My goal is to have a chart with both cumulative (as line in chart) and monthly (as clustered column in chart) data. I have achieved this but when I use timeline or slicer the chart selections (Running total and monthly) resets to only have clustered columns.
Do have something fundamentally wrong here or how should do the pivot table/chart in order to use slicers and timeline -tools?
DATA-sheet
I have the following columns:
DATE, DATA 1, DATA 2, ... DATA 10
PIVOT-sheet
I have Pivot-table:
Colums: Year
Rows: Month
Values: DATA 1 (Sum) and DATA 1 (Running total)
Bookmarks