Forum Discussion
Creating an energy usage chart
Your question has been up here for two days now with a fair number of views but no replies. I'm one of those that looked back on Tuesday when it first appeared. My reaction at the time was to say, "we need a bit more definition here; maybe somebody else will ask for that."
So let me be the one to ask for it. It really looks like you already have what you need. So what help are you asking for? Could you spell it out a bit more? What have you tried already? [FWIW, there's no shame in reinventing the wheel; you might learn something along the way, or discover a solution nobody else had thought of.]
Anyway, absent further definition from you, let me suggest you take data such as you show in your inquiry, data for a full month, highlight it all, and then select Insert....Pivot Table.... and play around a bit with what the Pivot Table can do for you. And once you've gotten a nice summary in the Pivot Table, add a graph by selecting the "Pivot Chart" option on the far right of the PivotTable Analyze tool bar. You can't break anything by doing this, and you might come up with your own "wheel."
Then come back and ask some follow-up questions.