ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Secondary axis on 3d charts (https://www.excelbanter.com/charts-charting-excel/89516-secondary-axis-3d-charts.html)

MH UK

Secondary axis on 3d charts
 
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

Secondary axis on 3d charts
 
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" wrote in message
...
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





All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com