plot groupings of series

[Jimmy G ''73]

I would like to plot a number of groupings of three bar series such that I
show three values grouped together for one location, then plot the three bar
values for the next location, and so on. The three values should be beside
each other for each location.

 

[Jon Peltier]

Jimmy -

Set up your data like this:

Value 1 Value 2 Value 3
Loc 1 xxx xxx xxx
Loc 2 xxx xxx xxx
Loc 3 xxx xxx xxx

The top left cell is blank. Select the whole range, and create a stacked
column chart.

- Jon