2D vs 3D chart

[JMac]

I am using the Line - Column on 2 Axes chart from the
Custom Types tab. I want to make the bars 3D rather than
2D. Any ideas on how to accomplish this?

Thanks

 

[Tushar Mehta]

There are certain combination charts that XL will not do. One of them
is what you want.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Aside from Excel not letting you do this, there are technical reasons to
avoid this kind of formatting. Applying false 3D effects like this to a
chart might make it "pretty", but it also makes the data harder to read.
You can perhaps compare the relative heights of the bars, but it's a
bear to try to read where on the axis the bar ends.

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

 

[Tushar Mehta]

Presentation overkill is an issue that should not be ignored, but it is
eminently possible to improve on the aesthetic quality of a default XL
graph.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004

 

[Jon Peltier]

What, you don't like gray backgrounds? <smirk>

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