[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can I create a triangle surface plot in excel

Posted on 2010-11-18
5
Medium Priority
?
1,453 Views
Last Modified: 2012-05-10
I would like to create a "triangle surface" plot in excel. It would have 3 axes, let's call them income expenses, and overhead.  I want to be able to put one point on each axis and then create a triangle.  

I am trying to visually compare different scenarios that are defined by income, expenses, and overhead by showing each scenario as a triangle surface so that my audience can visually see the trade-offs between the scenarios.

Is it even possible to do what I am asking in Excel or do I need some other type of charting program?
0
Comment
Question by:umrminer
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:hitsdoshi1
ID: 34165313
The closest to your need is Pyramid chart type and cone chart type in excel chart.....for exact triangle...my best guess is thrid party solution...Good Luck !
0
 
LVL 7

Accepted Solution

by:
TonShadow earned 2000 total points
ID: 34170574
Hi,

Just a suggestion, how about this way of presenting the scenarios? It is quite visual also and more or less similar to your request.

Ton

 Kind-of-a-triangle.xls
0
 

Author Comment

by:umrminer
ID: 34172415
TonShadow,

That's awesome, thanks.  One last question, can I add more than one group of point so I can show multiple scenarios on one chart?
0
 
LVL 7

Expert Comment

by:TonShadow
ID: 34172429
Hi,

yes you can just add new series but they will overlap and it might be hard to read if several scenarios. But I think you can try whether they remain easy to read or should you just simply separate each scenario in own chart.

Ton
0
 

Author Closing Comment

by:umrminer
ID: 34172437
Awesome, simple solution!  Thanks!
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question