GRAPH - 2 stacked bars under one heading

[LeighO86]

Hi all,

Graph's are not my strong point.

I have a set of data. Territory as my x axis and revenue as y. Using a stacked graph the revenue can be split out by business stream.

What ideally i'm trying to do is put UK as a main x axis, then have 2015 as one bar and 2016 next to it. Which will then be stacked by stream, same as before.

Does anyone know how to do this, or if its possible. I find excel a bit limiting with graphs or it may just be me .

Any suggestions would really help.

Leigh

 

[pbornemeier]

This technique may give you what you want: Clustered and Stacked Column and Bar Charts - Peltier Tech Blog