Pivot Chart Layout

[Stubaru]

Hi everyone,

I want to make a pivot chart to track performance of drivers in a race series.

I can make it as a normal chart, but would like the have the filter options to remove certain drivers, or compare directly.

I'm unsure on how to layout the data source, and seem to be having issues with the X axis in particular.

What I would like is the following:

Y axis: Race finish value (these have been assigned a numeric value from 1-50, 50 for a race win, 1 for a NA, 2 for disqualified etc)
X axis: Race name (I'd like it to be in the order of the table)

Data: Driver name to be plotted on a line graph


My current table is formatted as follows:


Team Driver R1 R2 R3 R4 R5 ....
T1 D1 50 35 20
T2 D2 35 43 47
T3 D3 1 20 28


Do I need to assign a numeric value to the Races for them to appear on the X axis? On a normal line graph I can plot the actual race names in the correct order.


I've not used pivot charts in a while, and it seems they have changed since I used them last time. I remember being able to just click and drag options onto chart directly and position it how I would like it to be displayed.

Thank you...