We Saw a Chicken …

Tag: chart

  • 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.

  • 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.