Recreating Bar chart with Quartile Summary Data

[westcoast123]

Hi - I'm trying to recreate the charts below in excel with the underlying summary data and not sure where to start. Not sure if this possible via box plot or bar chart?

 

[hagia_sofia]

Hello, the starting point could be combined Stacked Column Chart & XY Scatter Chart. First you will create a Stacked Column Chart with three categories, i.e. 75th percentile - median, median - 25th percentile and 25th percentile, then you will insert median values and change it to XY Scatter Chart. Cf. the attachment.

 

[westcoast123]

Hello, the starting point could be combined Stacked Column Chart & XY Scatter Chart. First you will create a Stacked Column Chart with three categories, i.e. 75th percentile - median, median - 25th percentile and 25th percentile, then you will insert median values and change it to XY Scatter Chart. Cf. the attachment.

Thanks, this is helpful. Few follow ups- creating a stacked column chart and plotting the median as XY scatter chart gave me the below. How would I adjust so x-axis doesn't start at 0 and plot the ranges as you had above? If possible, if you could share the underlying excel that would be appreciated.

 

[hagia_sofia]

Hello, many thanks for the feedback - you are probably right that a file might be more useful than many words, so: file.

Just one thing I did not realize is that the correct data setup should be 25TH, MED - 25TH and 75th - MED (an alternative approach is to switch order of the series). X axis will start with 0 the trick is to make the first series invisible.