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! |
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! |
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! |
All times are GMT +1. The time now is 10:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com