Chart with grouped and floating bars

[r3pooc696]

It would be easier to show you an example, but I cannot post attachments...

I am trying to create a chart with grouped, floating bars. In my example, I have 4 groups that each have 3 floating bars (some are crossing the x-axis).

This is the most difficult chart formatting I have attempted yet so any help would a blessing.

Thank you.

 

[Worf]

Welcome to the Board

To share something, upload it to a hosting site like Drop Box and paste a link here.

 

[Jon Peltier]

I have a couple tutorials that might help. Keep in mind that floating bars are stacked bars, with filled bars floating on bars which have no formatting to make them invisible.

Clustered and Stacked Column and Bar Charts

Floating Bars in Excel Charts