Forum Discussion
Pivot Pie Chart for Excel Table - Filtering by dates and staff
I want to build a pivot cart that will go off this table that contains month to month employee performance grades. The table headers are months (1/1/2021, 2/1/2021, 3/1/2021, 4/1/2021...) The ta...
Hi DN4559,
in order to use a Pivot chart, your data needs to be in a "flat" table structure and not in a tabular one.
So, the very first thing you need to do is to convert the data from your current structure into something like this:
1. Source data (which is a formatted table)
2. Create the chart: menu "Insert | PivotChart"
3. Insert Timeline: menu "Insert | Timeline"