Double float stacked bar chart for each series

**peterputter** · 10-31-2013, 02:37 PM

Hi,
This is my first submission for help. Found a solution to float a bar chart but only works for single data. Attached sheet shows both single and double data necessary for display. When grabbing all the data, the timeline does not display correctly. Specifically, I'm trying to display the DURATION column of data only, starting at the end of each rise times.

Thank you,

peterputter

**DBY** · 10-31-2013, 03:22 PM

Hello
Take a look at the attached example. Is this what you're looking to do? If so, you should be able to work it out the method as you already have a grasp on the floating bar chart.

Hope this helps.
DBY

**peterputter** · 10-31-2013, 08:16 PM

OMG! I stared and fiddled with my chart forEVER and your solution is so perfect!!!!
Thank you, it's EXACTLY what I needed. Genius!!!!

**SeekingAnswers11** · 01-04-2016, 11:53 AM

Hello, all! I am still learning my way around Excel, past the basics, so please bear with me

I am attempting to create a double-column floating bar chart which shows pre- and post-production data. I have created a floating bar chart for pre-production data, but cannot figure out how to add a second column, within the same table, to compare the data sets.

Essentially, I am trying to determine what the difference was between what my team predicted we would find versus what we actually found. The bottom of each bar shows the low end (P90) and the top of each bar shows the high end (P10) for each project. This is pre-production. I have another data set for P90/P10 post-production, which I would like to use to create a second column next to each currently-existing orange column, to show the difference.

I am still recovering from the craziness of the holidays, so I hope my explanation and request for help suffices. Please let me know what additional information I can provide, and THANK YOU in advance.