Column Chart: X axis text values with mutiple series

[Tzepesch]

Hi everyone.

We want to create a chart, which shows four categories (bone-biopsies) on the x axis, time on the y axis (decalcification time) and different series (descaling, method) in columns coloured differently in the chart. This chart is almost perfect, except it puts the columns in the wrong categories:

knoglemateriale-afkalkningstid-afkalkningsmiddel-metode.png

There was almost a fix made on this thread, except it didn't include multiple series. (It makes an X Y Scatter and colours error bars with 100% to create the columns)

I hope the image above illustrates how I was hoping we could make it look.

How can we get the multiple series to be illustrated in columns next to each other in the right categories?

Download Excel file via Dropbox