plot groupings of series

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jimmy G ''73 - 31 Jul 2006 19:25 GMT

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.

Reply to this Message

Jon Peltier - 01 Aug 2006 04:59 GMT

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
_______

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

Reply to this Message