Tue, 19 Dec 2023 05:08:23 +0000 http://www.greenbuildingforum.co.uk/newforum/ Lussumo Vanilla 1.0.3 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299364#Comment_299364 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299364#Comment_299364 Fri, 23 Dec 2022 11:46:40 +0000 WillInAberdeen
The formula in cell M13 is looking at cell A13 which is zero, then it subtracts A12 (a recent date) from that zero, so ends up with about -45000.

Instead of (A13-A12), you could try MAX((A13-A12),0) which will return 0 instead of any negative number.

There's several ways to do this, all good whichever you like.]]> http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299365#Comment_299365 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299365#Comment_299365 Fri, 23 Dec 2022 12:31:03 +0000 barge17
"the cell youre talking about is selected and the formula in that cell is displayed at the top of the page-" yes, sorry, will do in future.

Meantime, I have tried =MAX((A13-A12),0) and that is returing Zero. So I shall copy that across the row and see how it looks this afternnon. (assuming the weather here in Lancs is still going to be utterly crap!)

Cheers]]> http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299400#Comment_299400 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299400#Comment_299400 Tue, 27 Dec 2022 13:22:22 +0000 borpin
Each month, select top (last) row of data by click on row number to select whole row, the right click on row number and *copy*. Then right click on row number again and select *Insert copied cells*.

It inserts the copied row above the existing row. Keeps all the formulas intact and all I do then is enter the date and the readings.

Because I use named ranges, the charts automatically update.]]> http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299428#Comment_299428 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299428#Comment_299428 Thu, 29 Dec 2022 16:07:23 +0000 barge17
So I think I am going to need to re - enter my data and formulas line by line in a blank part of the spreadsheet, then I shall have the convenience of seeing my latest data without having to scroll for it.]]> http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299431#Comment_299431 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299431#Comment_299431 Thu, 29 Dec 2022 17:37:15 +0000 LF http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299432#Comment_299432 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299432#Comment_299432 Thu, 29 Dec 2022 18:33:41 +0000 barge17
well, as we probably all know, once you start fiddling with a thing, the more you do of it, the slicker you become, and less worried about the consequences. I'll see how it affects a simple chart, but future dates are not an issue for me, just ones with completed data.]]> http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299442#Comment_299442 http://www.greenbuildingforum.co.uk/newforum/comments.php?DiscussionID=17628&Focus=299442#Comment_299442 Fri, 30 Dec 2022 19:29:24 +0000 borpin Posted By: LFFor charts if you edit x axis, you can not display the future dates by adjusting the max value. Only half read about issue, this morning so may not be useful. Glad you have achieved so muchOr used named ranges that adjust with the added data.

Search on "excel named range chart offset"]]>