Solved

Can I create a triangle surface plot in excel

Posted on 2010-11-18
5
1,382 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 500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

856 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