Solved

Can I create a triangle surface plot in excel

Posted on 2010-11-18
5
1,348 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Awesome, simple solution!  Thanks!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now