Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3-D Chart
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! |
#2
|
|||
|
|||
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/ch...ace/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 In article , says... 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! |
#3
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |