chirayu
Well-Known Member
Hi All,
Last week I had a crazy idea - What if I could make a Donut chart that could show the values of 3 Site locations that all can total to 100% - So that would mean 300% in one Donut - And make it look like an Infograph (sort of hopefully :S).
Logically Impossible but Illogically Possible (I hear u thinking - he's gone crazy!!)
I spent some time and came up with the attached - hope you like it. The file explains how it was made.
Note - I have used RAND() formula to generate random values on sheet refresh & colour scheme used is from the company I work in.
Last week I had a crazy idea - What if I could make a Donut chart that could show the values of 3 Site locations that all can total to 100% - So that would mean 300% in one Donut - And make it look like an Infograph (sort of hopefully :S).
Logically Impossible but Illogically Possible (I hear u thinking - he's gone crazy!!)
I spent some time and came up with the attached - hope you like it. The file explains how it was made.
Note - I have used RAND() formula to generate random values on sheet refresh & colour scheme used is from the company I work in.