Column Chart: X axis text values with mutiple series

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

Forgive me but I can't see what's wrong with your current chart. Can you give an example or two of erroneous plots, and where you would expect them to be?

Regards

Sorry again. Still confused. Your data table does not have three "high" values for "knoglebiopsi", and its eight values - 168, 6, 6, 6, 6, 1.5, 1.5, 1.5 - are all displayed correctly as columns in the "knoglebiopsi" section of your chart.

The four "Columna" values from your data table - 50,18,6,1.5 - are also represented correctly in your chart.

I'm wondering if the issue is not so much your chart as the arrangement of your data table? Perhaps the issues you are describing are the results of having filtered/sorted the data table, though unless I'm mistaken the unfiltered version that you have in the attached file does not show either of the two issues you have just pointed out.

Regards

use a pivot table/chart