Technical notes to myself: • Delete any bad refs in the “original” chart (odd things happen when you delete something like Claymore. Don’t worry!) • Copy chart to start a new graph • Make sure x-axis only tics at one day before labeling • Isolate the chart data (typically 3 days) in the 15 min table and add a row of legend labels at the top of selection range • Select data by editing chart range. Should look like ='15Min'!$B$11377:$R$11666 which can be pasted, but only through right click, not ctrl-v • Annotate with bold labels; make subject line red • Copy and paste special, enhanced metafile, with border • Add day of week Missing data comes in many flavors. Some individual observations were blank, some #N/A, some zero. Some hours completely omitted. Many diversions completely unmeasured. If it said zero, I kept it. If it was blank, I usually turned that into a #N/A. I've also been told that there can be issues regarding Daylight Saving Time.