How would I do a (clustered column) reliability chart in Excel? (The values 90%, 99%, 99.9%, 99.99%, 99.999%, etc. must be equally spaced along the Y-axis -- otherwise, it is not possible to distinguish between 99.95% and 99.9997%, for example.)
Sample data:
Equip Run 1 Run2 Run3
Equip1 93.4854% 94.5433% 93.9843%
Equip2 99.9942% 99.9989% 99.9953%
Equip3 99.9439% 99.9753% 99.9488%
Equip4 99.9993% 99.9994% 99.9994%
Equip5 99.9985% 99.9982% 99.9993%
What I don't want is for 93.5% bars to be by themselves and all the others clustered up near 100% (as happens when you use a linear chart).
Thanks.
Bookmarks