Categories
computers suck

Independent date x-axis in Excel charts

The Ask Metafilter question “Basic line graph” spurred me to make this unpretty graph:

Here are the input data:

You need to make an X-Y (Scatter) plot. All others don’t have fully independent X-axes. Make your chart by selecting the first two data columns, then Insert Chart. Once the chart is in, right click/Control-click (OS X) to get this context menu:

which should show

You can add more data series by hitting Add. Here are the specs for the next two series:

Finally, here’s the example spreadsheet: MultipleDateLinesChart.

Categories
goatee-stroking musing, or something

who loves the sun?

After my solar course, I’ve been messing about with the UO SRML: Sun chart program. It shows sun angles and day lengths throughout the year.

Toronto: where I live
Glasgow: where I'm from. Not much sun there, but looong summer days
Phoenix, AZ is pretty sunny
I think I'd freak out if I lived at the equator: every day is nearly the same length!
Mombasa, Kenya: point your modules north!
Not much sun in far north Alert; sometimes, the sun doesn't set — sometimes it doesn't rise
I don't think I'd mind living in Glasgow — Glasgow, Guyana, that is.