Generate pivot chart to get detailed daily power usage

Hi all,

I am newbie to pivot charts. I have got a pivot table with hourly power usage for every day of the month. I would like to generate a chart for everyday and then overlay all days on top of each other to figure out what hours are my peak uasges.

Can someone help me with that?

Pivot table is attached.

Create an "Hourly" column in your data with the formula:=MOD(A2,1), then create PivotTable and plot the chart.

Obviously you have to change the cell format. And, did you try to add this field in your PivotTable?

Originally Posted by josephteh

Obviously you have to change the cell format. And, did you try to add this field in your PivotTable?

Legend.

Thanks mate