Two columns per location

[Guest]

I've got 4 locations (Edinburgh, Birmingham, London, Manchester) and
information that I want to show for each location however I want to do a
chart where each location has two bars of information. The first bar will be
made up of information in two columns relating to two different types of
customer and the second bar will be made up of two further columns which
record information that adds up to a total. The chart is to show two
customer groups appointment which they've used this year and then what they
could have taken (i.e. free/unbooked appointments plus ones which they
cancelled with only 48 hours or less to go to the booking which meant that we
didn't have time to offer it to anyone else). I know how I could show the
information on two seperate charts but I can't work out how to show it on one
as my boss doesn't want it all in one column per location. Please help -
it's driving my poor afternoon brain round the twist!

 

[Del Cotter]

I've got 4 locations (Edinburgh, Birmingham, London, Manchester) and
information that I want to show for each location however I want to do a
chart where each location has two bars of information. The first bar will be
made up of information in two columns relating to two different types of
customer and the second bar will be made up of two further columns which
record information that adds up to a total.

It sounds as though you want a clustered stacked column chart:

http://www.peltiertech.com/Excel/ChartsHowTo/ClusterStack.html