Hi Guys,

Please help, I am having difficulty with Stacked Bar charts. I am trying to do a gantt chart.

I have 5 columns on my spread sheet these are:
Tasks - Text
start date - date format
end date - date format
days completed - numbers
days remaining - numbers

Now I can start a stacked bar chart by selecting the first and second columns.
I then right click on the chart choose select data
now, if I then add series which seems the logical thing to do, the whole chart is totally reformatted with dates at the bottom ranging from 00/01/1901 to 15/03/2023, and all the bars are the same colour and the same length.

What am I doing wrong. If you need me to post more info I can. I have been struggling with this now for nearly 4 hours, how do you do this?

I have been following a tutorial and downloaded his example, and it behaves how I would expect it to. I tried just putting my data into his example, but that doesn't work either. Can any one help me with please?

Kind regards

Rob K