Howdy

This may sound random and it might not even be possible but if anyone'll know it's you guys

I need a chart that shows data by width depending on the figures

For example, if I have 1 person who has had 10 days of sickness in a row I want a tall thin column showing 10 whereas if I have someone who's had 10 days of sickness but in 3 separate periods (i.e. 3days then 4days then 3days) I want a shorter, fatter looking column to show the same number of days but spread out over a longer period

Is this actually possible or have I imagined something Excel cannot do

Please help put me out of my misery...

Thanks

Dan