Triangle Chart in Excel Urgent

  • Thread starter Thread starter tuscofan
  • Start date Start date
T

tuscofan

Ok here we go:

I was in Management class yesterday and we were brainstorming and her
is what I need. I just need to know if it possible and maybe how.

I need the chart to be in the Shape of a Isosceles Triangle wit
wording on each out side length. Here is where it gets tricky. I nee
three boxes that three different precentages will be put into. Each o
the percentages represent a side of the triangle. Each percentage wil
fill or shade up that portion of the triangle (after entered in th
boxes) but must be able to overlap the other two percentages. I
essence forming a type of pie chart. But it needs to be in the shap
of a Triangle for our model to be correct.

Any help would be greatly apperciated.
Thanks in advance.
If needed I will post an image of what I am looking for
 
There are two parts to this problem and neither is easy. Below is an
outline of how to approach the individual problems, though not
implementable steps.

The first is calculating the position of the point where the three areas
touch. That requires some amount of algebra. Suppose the triangle is
(0,0), (X2, Y2), and (X3,0). Suppose the point inside the triangle is
some (Xi, Yi). So, there are now three triangles given by (0,0),
(X2,Y2) & (Xi,Yi); (X2,Y2), (Xi,Yi), & (0,X3); and, finally, (0,0),
(Xi,Yi), & (X3,0).

From what I remember, one can calculate the area of a triangle given the
three vertices. I imagine searching google for the information will
yield the necessary formula (I am not connected to the 'Net so I cannot
provide you with the formula). So, use the area of the three triangles
to calculate the (Xi,Yi) values. If you can work that out great, if
not, hopefully, someone will be able to help you.

The second part is to use an XL chart to simulate the effect. It can be
done with a area chart where the x-axis is time-valued. Here's one
example. Suppose the main triangle is (0,0), (3,25), and (4,0).
Suppose the Xi,Yi point is actually 2,10.

In A1:B4, enter:

1 0
2 10
3 5
4 0

Plot this as an area chart. Make sure the chart type is the first one.
Ensure that the 1st column is the x-values. Once done, select the
chart, then select Chart | Chart Options... | Axes tab. Change the x-
axis type to Time-scale.

Now, in some other cells, say, F1:G4, enter:

0 0
12.5 10
25 25
0 0

Add each of these columns as a new series to the chart.

Change the series order (double-click any plotted series, then click the
'Series Order' tab) to achieve the desired visual effect.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
Back
Top