Saturday, 25 February 2012

Latest Charts

After a large amount of magic jiggery pokery, and running across a brick wall of what excel can actually chart.

Going from a simple chart looking like this:

which doesn't give a clue as to the frequency of each event, to something like these two:

took three magic hours.

I had to go from a simple list of three items (a,b,c) to go to an (n by n) block in excel which could then be plotted as a bunch of 3d shapes/

Well, at least I know what to do, so it will be easier for the next couple of charts :-)

No comments:

Post a Comment