Triangular graph

jackdiamond

Board Regular
Joined
Oct 10, 2007
Messages
220
Hi,

I am looking to create a graph that can plot 3 lots of data. This needs to be a triangular graph so we can visulise hotspots.

Does anyone have any idea how this can be done please?
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Can you post a link to an example of what you're trying to do?
 
Upvote 0
You can only plot a triangular graph if a+b+c=100%

So you can create a triangular graph using an X-Y scatter by calculation -you can plot points using any two of a b and c as the third is fixed by the other two. You need to do a bit of fiddling to get it looking right though.

Depending on what you want the top corner of your triangle to be you set that as the Y value for your series (lets assume it is b and a is at 0,0 and c is the right hand side of the base)

You then calculate the X value as c+1/2b for each of your points (simple trigonometry) and plot your points in teh normal way for an X-Y scatter

Set your formats for the X and Y axes so they are fixed - minimum 0 maximum 100 and set the formats to make all the lines disappear

You then need to add 3 data series to provide the sides of your triangle - one from 0,0 to 50,100 and one from 50,100 to 100,0 and a third from 0,0 to 100,0

If you want to put in lines to provide a scale of grid lines to break up the triangle - say showing every 10% you need to calculate them using teh same formula and plot them as series too (so the line for 10% B which is parallel to the base plots from 5,10 (10% b and 90% a)to 95,10 (10%b and 90% c) and so on). Fiddle with the formatting of teh data series so it looks good and teh job is done;)
 
Upvote 0

Forum statistics

Threads
1,224,542
Messages
6,179,424
Members
452,914
Latest member
echoix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top