So, select any cell in your formatted Excel table, and in the Insert Tab on the ribbon, click the top half of the split "PivotChart" button.
Hourly Data are presented in Comma Separated Variable (.csv) format which is compatable with use in a spreadsheet such as MS Excel. These files can also be plotted with MS Excel. To save a file in ...