Best way to show quantities and ratio on same chart?

[hmmmidk220]

Hi!

I'm not sure if I can attach a file but here is my sample data:

		Early For Class		On Time	Late For Class		Grand Total	% on time
Person A		2438		535		546		3519	84%
Person B		127		41		17		185	91%
Person C		253		68		88		409	78%
Person D		520		93		101		714	86%
Person E		220		124		298		642	54%
Person F		489		109		89		687	87%
Grand Total		4046		968		1138		6152

<colgroup><col span="2"><col span="2"><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>

But basically I have some sample data with number of times 6 people have been early for class, on time, or late for class.

The most important thing I want to show is the % each person has been on time and early (just one value, just the sum of on time and early divided by the total). But since there is such discrepancy between the total volumes of each person, I also want to show somehow the total quantities. So I want the viewer to be able to see essentially how often each person has been late but also get a sense of the sample size of each person.

I've created a sample chart but I'm not sure how to show it? I just created a chart that is a stacked column of each quantity (x axis is person name) on the first series, while the second series is a line chart that just plots the % on time. Is there a better way to show this? I feel like people usually associate line charts with the passage of time which doesn't make sense here. Also since showing the % late is the most important thing, it doesn't pop out as such since it's a line on the second series. Not sure...

Any advice?

Thanks!​

 

[hmmmidk220]

Anyone have any ideas? I thought about a pie chart where the quantities are shown and then in each slice I put the % late, but that's confusing because I want to show % late and not % of each quantity..if that makes sense. Any ideas?

 

[hmmmidk220]

Bump ?