Can I create a triangle surface plot in excel

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?
umrminerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
TonShadowConnect With a Mentor Commented:
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
 
hitsdoshi1Commented:
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
 
umrminerAuthor Commented:
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
 
TonShadowCommented:
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
 
umrminerAuthor Commented:
Awesome, simple solution!  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.