plot groupings of series
 

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.

plot groupings of series
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jimmy G ''73" wrote in message
...
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.