Excel Help

[Deleted User]

JohnSwift10 said:

Now to figure out how to do a pivot table

1. Highlight all your data including a column heading for your two columns (date&time, consumption)
2. Go to Insert > Pivot Table and click ok
   
   
   
   
   
3. Drag "Date" down to the "Rows" box
   
4. Drag "Consumption" down to the Values box
   
   
   
   
   
   
5. Then click on any cell in the Row Labels column on the pivot on the sheet and go to the menu PivotTable Analyze > Group Selection
   
   
6. In the pop up, highlight "Days" only by clicking and clicking on it as per screenshot below.
   
   
   
   
   
7. Click ok then you will have this:
   
   
   
   
8. Pivots are really powerful for this kind of work for several reasons:
   
   
9. Not fiddly like formulas, less likely to make mistakes
   
   
10. If you actually highlight column A and B in step one, the pivot can use any future data you add to it, all you need to do is right click on the pivot and select "Refresh" to include new data
    
    
11. If you select "month" as well in step 6 so can have your pivot group by both days and months like this with expandable "+" symbols:
    
    
    
    
12. You can also transform the data easily into different cuts - so here is the hours listed and the consumption during each hourly period for months of Jan and Feb.
    
    
    

JohnSwift10

Thanks tallmansix