CHART-Clustered Column, need help on a 3 column variation

[itr674]

I am trying to get a column / bar chart variation to work with four columns. I am using instructions from Walkenbach's Excel Charts book page 258.

I want to add a forth column and have the three clustered columns inside the Orders column. I have been able to get the staked column converted into a clustered column inside the Orders column, but when I try to add a third column nothing works? The third column is hidden by the other columns???

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows XP
(F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
A1 =
	A	B	C	D	E
1	*	Orders	Inventory	In*Production	Parts*On*Order
2	B100	900	500	300	100
3	B200	900	400	100	100
4	C300	1000	300	500	200
5	D400	1300	100	200	500
Sheet1 *

[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

[itr674]

throwing this back out there for the Monday morning folks...

[fairwinds]

Hi,
Jon helped me a while ago.
Maybe it helps you?

http://216.92.17.166/board2/viewtopi...504&highlight=

[itr674]

fairwinds - thnaks, I will study suggestion tonight couldn't get it to work quickly so I will have to study, study, study..

In the mean time I thought you could--
1. set one chart on top (directly on top, not above) another chart, and
2. then set the area pattern to none making that chart transpartent, and
3. then set one chart on the other, and
4. finally set the "order" of one so it goes to the back???

If I could get this to work it would be a temp fix...

I'm using Office XP and the "order" is not highlighted when I have a chart selected?

[itr674]

Dis-regard -- the "bring to front" is at the bottom of the drop down -- I just can't see today--hell maybe everyday...