create a new type of stacked column chart not available in Excel

[pasquale.lanera]

Hi
I have a little problem, maybe !

I have data on concentration of 4 chemical contaminants in marine sediments. The sediments have been sampled at 4 different distances from an offshore platforms (0, 25, 50 and 500 m) and at two different depth sediment level (0-2 cm and 8-10 cm).
I would like to show these data in only one chart, but with Excel 2007 it seems not possible. The data are displayed in two column stacked bar: one for the 0-2 cm level and another for the 8-10 cm level.
But with statistical software SPSS it is possible but it is not ease to manage many chart.

Is it possible to build a new chart tipe or to combine two types (3D stacked column and 3D column with a depht axis ?
Or could you give me a tip to realize a chart to display these data ?

The data and my relized charts are available on attached excel file.

[Andy Pope]

Not possible in a single chart.

You would need to make multiple charts and position them in order to fake it.

[ptm0412]

I have made 2 types, but I don't know if you like them.
I just only rearrange the data

[pasquale.lanera]

Thanks a lot. Your charts are very interesting and could a be a good alternative !!!