MS Excel and graphs

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?

Reply to
Harry Bloomfield
Loading thread data ...

This is what I use, any good?

formatting link

Reply to
ss

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?

Reply to
Harry Bloomfield

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

Reply to
ss

ss pretended :

Emailed!

Reply to
Harry Bloomfield

HomeOwnersHub website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.