Charting using Stacked Column Graph

[Greta]

Excel 2002...
I think I posted this in the wrong place before.
I'm trying to chart a series that is comprised of 5 - 3
number groups. I can chart the first group, but when I
try to add the next series, it stacks them onto the
existing columns rather than make 3 new ones.
The data looks like this (simplified):
A1 A2 A3 B1 B2 B3
1-10 .01 .03 .58 .023 .025 .023
11-15 .012 .025 .025 .024 .588 .280
16-20 .012 .255 .158 .024 .254 .241

I get a nice chart with A1-A3...but can't add B1-B3 next
to it.
Help me, please.
Thanks,
Greta

 

[Tushar Mehta]

If you want side-by-side stacks, you need to do something like Stephen
Bullen's funchrt4.zip at
http://www.bmsltd.co.uk/excel/SBXLPage.asp#Charting

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Greta -

Tushar and I often read questions differently. As I see it....

Right click on the chart, choose Chart Type from the pop up menu, and
select the Clustered Column type, not the Stacked Column type.

Also, you can build the chart all at once, not just one series at a
time. Select the entire range (or a SINGLE cell within the range), then
run the chart wizard and draw a clustered column chart.

- Jon