2nd Axis on 3D Column chart

First, using XP, is this possible?

Second, if it is possible, I have four columns of data like below:

A B C D
1 70,000 60,000 7,000 4,000
2 80,000 70,000 8,000 5,000
3 90,000 80,000 9,000 6,000
4 100,000 90,000 10,000 7,000

My boss wants a 3D column chart with the data arranged (from back to front) A,B,C,D. I want to put Columns C and D on a second axis, but I cannot find this option in Excel or on the boards.

Thanks in advance for your help.

Hi cwilson,

Unfortunately with 3d charts you can not use the secondary axis.

If you need the secondary axis then maybe you could use Shadow or the
move advanced fill effects to give a less flat appearence and keep the
boss happy

Cheers
Andy

cwilson wrote:

First, using XP, is this possible?

Second, if it is possible, I have four columns of data like below:

A B C D
1 70,000 60,000 7,000 4,000
2 80,000 70,000 8,000 5,000
3 90,000 80,000 9,000 6,000
4 100,000 90,000 10,000 7,000

My boss wants a 3D column chart with the data arranged (from back to front) A,B,C,D. I want to put Columns C and D on a second axis, but I cannot find this option in Excel or on the boards.

Thanks in advance for your help.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy. That is what I thought.