View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.