Hello
found a pretty neat tutorial on how to create a 3d histogram in excel here.
Advanced Graphs Using Excel : 3D-histogram in Excel
Making the 3d histogram works fine but I would be able to colour the 3D boxes according to a third variable. Currently I just have a matrix where the values in the matrix dictate the height of each 3D box. That is fine. But now I would need to be able to colour each box according to another variable (so that height and colour are not related). I know I could do that manually but my matrix is 20 times 20, so any other solution woudl be appreciated
found a pretty neat tutorial on how to create a 3d histogram in excel here.
Advanced Graphs Using Excel : 3D-histogram in Excel
Making the 3d histogram works fine but I would be able to colour the 3D boxes according to a third variable. Currently I just have a matrix where the values in the matrix dictate the height of each 3D box. That is fine. But now I would need to be able to colour each box according to another variable (so that height and colour are not related). I know I could do that manually but my matrix is 20 times 20, so any other solution woudl be appreciated