2nd Axis on 3D Column chart

C

cwilson

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3D column 0
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
create chart with column axis 10
clustered 3d column chart 0
Consolidate my data and plot on a dual axis chart 3
Points Dimensions on a 3D Clustered Column Chart 4
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Aligning an excel table w/ a cluster column chart x-axis columns 2

Top