Forum Discussion
Box and whisker plot issues
Hi I am trying to create a box and whisker plot for some data for which I already have the summary statistics (min, max, median, IQR). Excel creates the box and whisker plot however it either lump...
Hi!
Unfortunately, your source data is in wrong format. The Box & whiskers plot in Excel needs raw data - not aggregated Quartiles, means etc. You must give all data points to get the correct output. Excel will calculate all metrics itself.
I hope it helps!
Unfortunately, your source data is in wrong format. The Box & whiskers plot in Excel needs raw data - not aggregated Quartiles, means etc. You must give all data points to get the correct output. Excel will calculate all metrics itself.
I hope it helps!