Make bars stack instead of cluster in a stacked bar chart

[Anonymous]

Hello,

I have data like this:

Which is producing a graph like this:

I would like the two colours of blue to be stacked together in a single line. How can I achieve this?

See sample case with wrong orientation: 

[Anonymous · Accepted solution]

It eventually just sorted itself, now the graph is displaying correctly. 

[Anonymous · Accepted solution]

It eventually just sorted itself, now the graph is displaying correctly. 

[truptis]

Hi @Anonymous ,

You can try using "100% stacked column chart" ->(it will display something like this - see the screenshot for your reference)

Put your date column(1st column) in X-axis, 3rd column in Y-axis and 2nd column in Legend. 

@Anonymous -> Please hit the thumbs up & mark it as solution if this helps you. Thanks.

[Anonymous]

I need the relative sizes of the bars, so 100% doesn't work.

[truptis · Accepted solution]

Try Stacked column charts.