3-D Chart

[Guest]

HELP!!!

I am trying to create a 3-dimensional chart. My X-Axis will be "Lead
Source". My Y-Axis will be "Count" and the Z-Axis should be the "Year". The
idea here is to see how the counts have increased from year-to-year.

I am having some difficulty in trying to figure out how to build this
relationship. I have multiple worksheets with each year's data. Do I have to
get this on one work sheet before I can try and make this happen?

Any help would be GREATLY appreciated.

Thanks!

 

[Tushar Mehta]

This should be possible. However, depending on how you define the x,y,
and z axes, you may have to reorient them to match XL's expectation.
For a short tutorial see 3D Surface
http://www.tushar-mehta.com/excel/charts/3d_surface/index.html

--
Regards,

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

 

[Jon Peltier]

All the data for a 3D surface or contour chart has to be arranged in a rectangular
range on a single worksheet. I've written a tutorial about these charts:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=447

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