Rearrange a dataset using the old version of a Pivot Table
Category: Pivot Table
Use a pivot table to calculate the one sigma standard deviation of the variation in ozone concentrations during the whole of the measurement period and then insert error bars into the chart of one standard deviation.
Hourly ozone concentrations collected at Weybourne in the UK 2010-2014. Make a pivot table to calculate average monthly diurnal (daily) cycles and then plot them in a chart. Format the chart and add text boxes to label each month.
Chart of average seasonal daily (diurnal/diel) changes with pivot table