MS Excel and graphs

Feb 14, 2017 4 Replies

Being a bit anal about such things, I sought out a spreadsheet so as to keep tabs on my electricity and gas consumption, plus spending many months ago. I then adapted it to provide weekly readings. I stopped bothering with it when I moved to a Smart Meter, where our provider put up various graphs on their website.



After moving to a new provider in November, where the SM once again became dumb, I resurrected the idea of manually logging the data with the intention of resurrecting the spreadsheet, which I have just done.



Now I would like to improve the spreadsheet, so as to provide some neat weekly consumption graphs. I know it can be done, but how please?


This is what I use, any good?

formatting link

Yes, that sort of thing, but weekly as I have weekly data. I could maybe provide you with a copy of my own spreadsheet, complete with data for you to look at if it might help?

Yes send it and I can have a look or I can change mine to be weekly. Weekly it will end up pretty long after a couple of years. I put my figures in weekly for each month so I get an `adding` total as the month progresses.

email substitute `noname` with weels51

ss pretended :

Emailed!

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required