Secondary axis on 3d charts

[MH UK]

How can I use secondary y axis on a 3d chart - when switching to 3d chart
types, the option to select the axis is removed.
I have seen an example - though don't beleive that it orignated from excel.
Is there a work around?

TiA

[Jon Peltier]

Most chart workarounds involve using additional series not to display data
but to recreate the desired effects. In addition to their shortcomings in
terms of displaying data clearly and accurately, 3D charts do not
accommodate combination charts (charts with added series). It's generally
better to use a 2D type chart anyway, for improved transfer of information,
and to add additional features.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"MH UK" <[email protected]> wrote in message
news:[email protected]...
> How can I use secondary y axis on a 3d chart - when switching to 3d chart
> types, the option to select the axis is removed.
> I have seen an example - though don't beleive that it orignated from
> excel.
> Is there a work around?
>
> TiA