Adding to Stacked Columns

[SaintAugustine]

Hi all - another super-urgent question. I'm working with a coworker's graph of stacked columns. A client (the same one as before) just asked me to remove two of the three types of data displayed and to add a new one. I've added the new one, but I want it to be displayed underneath the remaining column. Instead, the Powerpoint chart maker graphs it on top of the remaining column, and bumps up the total number accordingly.

Basically, my source data goes:
Year| Widgets | Total Production | (NEW) Woggles
1999| 55 | 100 | 10
2000| 20 | 110 | 15
2001| 33 | 117 | 65
2002| 37 | 150 | 90

Right now, the graph displays a colored column for Total Production, and Widgets is a differently colored column within the Total Production bar. This is good.

But when I try to add Woggles, Woggles goes on top of Total Production, rather than within it. And, Excel/Powerpoint thinks that the new number of Total Production is 240, when it should still be 150.

Moving the order of columns from Widget/Total/Woggles to Widget/Woggles/Total didn't seem to make any difference.

Any help???

 

[xlhelp]

Hi!

Once you have added the series, right click on any data series in the chart. Choose "Format Data Series". Select "Series Order" tab and move Woggles up as you desire.

HTH

Indu

 

[SaintAugustine]

Good answer, but Move Data Series only moves it to the left or right of another series. It doesn't superimpose.

I just talked to the person who made the chart - she did it by dividing numbers (or something). I'll ask her to explain it more and then post it here when she's done (because it makes for a spiffy-looking chart!)

 

[xlhelp]

If you like, you can send me the file and I will take a look at it. Charts are so hard to describe and (at least for me) to understand from description.

Indu

xlwrdhlp@clarica.com

 

[xlhelp]

Hi, were you looking for something like this? (My first try to include an image, so I hope it works).

Indu

 

[xlhelp]

Sorry I mistyped.

Here goes again

 

[xlhelp]

OK, if it doen't work this time, I will give up.

Indu

 

[SaintAugustine]

Wow, nice looking chart =)

It's hard to say without the legend - if the yellow bar represents the TOTAL of 1999 (at 100), and the magenta and blue or portions of that total (at 60 and 70), then yes, that's what I'm aiming for.

However, if the three combined equal 100, then that's not what I'm looking for.

Does this make sense? I'm coming dangerously close to confusing myself...

 

[xlhelp]

Yes. Yellow is the Total as is on the worksheet. Widgets (purple) are at the bottom and Woggles (blue) are stacked on top of Widgets.

Indu

 

[xlhelp]

Yes yellow is the Total as is on the worksheet. Widgets are at the bottom and Woggles are stacked on top of Widgets.

Indu