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/P...cle.asp?ID=447

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

RTP wrote:

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!