La Luna - Moon phases animated chart in Excel

posted Oct 19, 2015, 1:36 PM by Krisztina Szabó   [ updated Oct 19, 2015, 1:38 PM ]

Freddy: Gone, gone, we've got to find him, do you understand?

by The FrankensTeam

It was just an experiment… First I tried with radar chart, but I realized it could not work. So finally we used stacked area chart combined with pie chart to make splot area perfect square.

The calculation behind the chart is not complicated - we used the equation of ellipse to model the border of lighted and shaded parts.
You can start the animation which will increase the time by 2 hours in 360 steps - simulating approx. one month.
You can download our file to play with it.

Krisztina Szabó,
Oct 19, 2015, 1:36 PM