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:

[TABLE="width: 759"]
<colgroup><col span="2"><col span="2"><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Early For Class[/TD]
[TD] [/TD]
[TD="colspan: 2"]On Time[/TD]
[TD]Late For Class[/TD]
[TD] [/TD]
[TD]Grand Total[/TD]
[TD]% on time[/TD]
[/TR]
[TR]
[TD]Person A[/TD]
[TD][/TD]
[TD="align: right"]2438[/TD]
[TD][/TD]
[TD="align: right"]535[/TD]
[TD][/TD]
[TD="align: right"]546[/TD]
[TD][/TD]
[TD="align: right"]3519[/TD]
[TD="align: right"]84%[/TD]
[/TR]
[TR]
[TD]Person B[/TD]
[TD][/TD]
[TD="align: right"]127[/TD]
[TD][/TD]
[TD="align: right"]41[/TD]
[TD][/TD]
[TD="align: right"]17[/TD]
[TD][/TD]
[TD="align: right"]185[/TD]
[TD="align: right"]91%[/TD]
[/TR]
[TR]
[TD]Person C[/TD]
[TD][/TD]
[TD="align: right"]253[/TD]
[TD][/TD]
[TD="align: right"]68[/TD]
[TD][/TD]
[TD="align: right"]88[/TD]
[TD][/TD]
[TD="align: right"]409[/TD]
[TD="align: right"]78%[/TD]
[/TR]
[TR]
[TD]Person D[/TD]
[TD][/TD]
[TD="align: right"]520[/TD]
[TD][/TD]
[TD="align: right"]93[/TD]
[TD][/TD]
[TD="align: right"]101[/TD]
[TD][/TD]
[TD="align: right"]714[/TD]
[TD="align: right"]86%[/TD]
[/TR]
[TR]
[TD]Person E[/TD]
[TD][/TD]
[TD="align: right"]220[/TD]
[TD][/TD]
[TD="align: right"]124[/TD]
[TD][/TD]
[TD="align: right"]298[/TD]
[TD][/TD]
[TD="align: right"]642[/TD]
[TD="align: right"]54%[/TD]
[/TR]
[TR]
[TD]Person F[/TD]
[TD][/TD]
[TD="align: right"]489[/TD]
[TD][/TD]
[TD="align: right"]109[/TD]
[TD][/TD]
[TD="align: right"]89[/TD]
[TD][/TD]
[TD="align: right"]687[/TD]
[TD="align: right"]87%[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD] [/TD]
[TD="align: right"]4046[/TD]
[TD] [/TD]
[TD="align: right"]968[/TD]
[TD] [/TD]
[TD="align: right"]1138[/TD]
[TD] [/TD]
[TD="align: right"]6152[/TD]
[TD="align: right"]

[/TD]
[/TR]
</tbody>[/TABLE]

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 ?