Thread: 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.

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" <JimmyG73@discussions.microsoft.com> wrote in message
news:40BCA132-40D6-4491-99A8-A5EEBECCA570@microsoft.com...
>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.