Recreating Bar chart with Quartile Summary Data

westcoast123

New Member
Joined
Jan 30, 2025
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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?
Exhibit_1_Performance_Persistance.png
Exhibit_2_Performance_Persistance.png
 
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.
 

Attachments

  • 1.png
    1.png
    63.6 KB · Views: 4
Upvote 0
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.
 

Attachments

  • Screenshot 2025-01-31 110619.png
    Screenshot 2025-01-31 110619.png
    17.5 KB · Views: 2
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top