How to create a simple "four area graph" in excel or google sheets?

Question

From a very basic dataset, I need to create this graph, but I'm struggling. Is there a simple way to achieve this in Excel or Google Sheets? Thank you.

Answer 1

In Google Sheets, you can create the desired chart using 'Area Chart' and a little bit of maths. You need to calculate the three Cartesian coordinates for the non-origin corners of each respective area (obviously they all have a corner at 0,0); assuming the values in your table correspond to the area of the square for each category, the sides of the squares are therefore of length √(area). The coordinates need to be formatted like this:

x	seqv	seqnv	simv	simnv
-3.464101615	0
-3.464101615	3.464101615
0	3.464101615
0		5
5		5
5		0
-5.830951895			0
-5.830951895			-5.830951895
0			-5.830951895
4.69041576				-4.69041576
4.69041576				-4.69041576
0				-4.69041576

The subsequent chart will look something like this (I have removed the edge lines):