Hello,
have you considered Box and Whisker charts to visualise that? They are new chart types in Excel 2016, but with a little bit of trickery they can be constructed in earlier versions of Excel, too. Jon Peltier has a tutorial on his site here.
BoxPlotV6.png
Yes hello, I have tried to follow that guide to create those charts but my excel Quartile function doesnt work as it is shown in the guide.
Example: I put in the formula =QUARTILE(AB22:AB50,1)
and I get "There is a problem with this formula" Are yo not trying to write a formula? etc, any ideas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks