Hi!
Please see the attached file. 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.
So using the data I have a sample chart in the attached file. It kinda shows what I want using a second series which is a line chart, but 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!
Bookmarks