Pivot Chart that shows Individual # vs Average

jb00976

New Member
Joined
Oct 23, 2017
Messages
32
I have data that is similar to the chart below with multiple entries for each individual. I want to be able to create a pivot chart that shows how many tasks of each complexity type an individual has completed vs the average of all the individuals where I can use a slicer to change the individual. What I can't figure out is how to get the overall average on there. Any help is appreciated

NameTask Complexity
JoeHigh
SarahMedium
MohamadLow
DilpreetOther
JoeMedium
SarahLow
MohamadOther
DilpreetMedium
DilpreetHigh
JoeLow
JoeOther
SarahLow
SarahLow
MohamadHigh
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
Average of what? Give an example using the data you've shown.
 
Upvote 0
Average of what? Give an example using the data you've shown.
Average of the different complexity types for all the individuals.

For example above for low there are 5 divide the 3 individuals is 1.67 average for all so I want to see Joe did 1 vs the average of 1.67
 
Upvote 0
That doesn't make sense to me. Maybe someone else will understand the maths of whatever that "average" is.
 
Upvote 0

Forum statistics

Threads
1,223,883
Messages
6,175,167
Members
452,615
Latest member
bogeys2birdies

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
Back
Top