Forum Discussion
Box and Whisker Problem
Hi everyone, Please can someone help or show me how I can make a similar chart in Excel as in the screenshot (this was in Graphpad Prism). Does anyone know how to layout the data? I only need to dis...
So you can use a 'stacked chart' to do this but you will need to add a helper column for the difference:
after i created the stacked chart I changed the formatting of the 'min' series to be no outline, no fill to give the floating look. as for the diff, I originally created the chart using min and max and then clicked on the max series and just shifted the range over to the diff column.