Excel Chart - Triangle shape instead of Pie Chart 1

[winwell1888]

I would like to represent data in as a triangle chart instead of a pie chart.

Does anyone know if it can be done (and how please)

Thanks

 

[GlennUK]

Explain how a triangle chart would work. I understand a pie ... the angle of the slice is propotion to the contribution to the whole. How would a triangle work exactly?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[winwell1888]

I can't really explain the maths behind it.

It would represent the data in the same way as a pie chart except instead of parts of the circle it would be sections of the triangle separated by horizontal lines. I was thinking about an area chart but can't get my head around it.

It would look something like below. So bottom area could be 70% of whatever, next layer, 20% and top part 10%.


/\
/__\
/____\
/ \
/ \
/__________\

I don't how you would draw the triangle to start with. Maybe use some VB code to create a triangle shape and then color it proportionately maybe by working out the areas of each piece of data??

 

[winwell1888]

That attempt at a triangle didn't work after i posted - sorry

 

[mintjulep]

The cone or pyramid chart types can do what you describe. They are 3D ish though.

 

[GlennUK]

Looking at a cone chart, I can see why no-one I've ever worked with has used them ... in my opinion the perception of the ratios of the data items by the viewer is not proportional to the mathematical ratios. It seems that I'm not alone in that thought:

http://www.mrexcel.com/Excel_Cone_Chart_Lies_training.html

If you use this type of chart you can make the 3-D view flatter to make it look like a triangle ... in Excel 2003 it's by changing the 3D view to Elevation of 0.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[xlhelp]

David Graham, of Loughborough University has developed a triangle plot using scatter chart. It's available here . Made my head swim. Please take a look.

Another at Geologynet's website.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
I should live a long time - I eat a lot of preservatives.