View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Xt Xt is offline
external usenet poster
 
Posts: 49
Default Triangulation chart

On May 11, 2:03*am, Duncs wrote:
Hope I can do the explanation justice, and that someone cna help.

I'm looking for a chart that will show three values, as follows:

The chart will take the form of a triangle. *In each of the corners
are the values 'A', 'B' & 'C'. *Each of the sides represent a value
from 0 to 100. *The idea is to take the data below and plot it into
the graph as follows:

A - 70
B - 60
C - 55

A line will go from corner A onto side BC, and stop at the indicator
for 70. *A line will go from corner B onto side CA, and stop at the
indicator for 60. *Finally, a line will go from corner C onto the side
AB and stop at the indicator for 55. *The aim is then to identify
where the three lines merge, if at all.

Is this possible, in Excel 2003, and if so how?

TIA

Duncs


Is ABC equilateral?
By "identify" do you mean by eye or by calculation?
Is this a standard chart used in some analysis and usually drawn by
hand?