First, using XP, is this possible

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

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

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