Charting using Stacked Column Graph

  • Thread starter Thread starter Greta
  • Start date Start date
G

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
 
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
 
Back
Top