Solved

Can I create a triangle surface plot in excel

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

786 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