woensdag 2 oktober 2013

Excel: The Rubik Square Graph :)

Just a toy: try to reorder the squares :) Of course it has got nothing to do with the Rubiks Cube. It was simply the first name I could think of.


What we actually see here is a Line Graph with Markers. I just changed all the markers into squares and made them larger. The color of the line I changed to noline.

The data from C2:J9 should look like this:

a b c d e f g
a 1 2,5 8,5 5,5 7 4 10
b 10 4 7 8,5 2,5 5,5 1
c 1 2,5 4 5,5 7 8,5 10
d 8,5 5,5 4 10 7 1 2,5
e 1 2,5 10 5,5 7 8,5 4
f 2,5 1 7 5,5 4 8,5 10
g 1 2,5 7 5,5 4 8,5 10

Now I have to figure out what I could use this technique for.

You can also download the file therubiksquare.zip through this link:
Een reactie plaatsen