Pivot Chart Layout

Stubaru

New Member
Joined
Mar 9, 2019
Messages
1
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...
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,123,241
Messages
5,600,499
Members
414,383
Latest member
konmtu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top