Answer the question
In order to leave comments, you need to log in
How do I plot a graph in Excel by value difference?
Hello.
I have hot water meter readings. I record these readings in a spreadsheet. The question is: how can I build a chart based on the difference in meter readings for the previous period?
Example:
Горячая вода (Показания счётчиков)
[+] [2018] [2019] [2020] [2021] [2022]
[01] Январь 26,00 43,80 56,36 70,86 82,49
[02] Февраль 28,00 44,80 57,04 71,93 83,76
[03] Март 29,60 46,12 58,93 72,46 84,71
[04] Апрель 32,10 47,06 59,69 73,81 86,30
[05] Май 33,00 48,20 60,57 74,83 87,45
[06] Июнь 35,00 49,09 61,53 75,37 88,05
[07] Июль 37,00 50,06 62,51 76,34 89,31
[08] Август 38,60 51,36 63,59 77,60 90,56
[09] Сентябрь 39,26 52,80 64,46 78,39 91,34
[10] Октябрь 40,86 53,90 65,37 79,60 92,76
[11] Ноябрь 42,12 54,33 68,90 80,40 93,48
[12] Декабрь 42,98 55,09 69,16 81,03 94,55
Answer the question
In order to leave comments, you need to log in
Or do I need a separate table in which the difference will be recorded, and already build a graph on it?
Add a column with calculated delta values and use it for charting.
You can't break it down into years. Let the readings go continuously in one column.
Месяц, год Значение Дельта
Январь, 2018 26,00 -
Февраль, 2018 28,00 2,00
Март, 2018 29,60 1,60
Апрель, 2018 32,10 2,50
Май, 2018 33,00 0,90
Июнь, 2018 35,00 2,00
Июль, 2018 37,00 2,00
Август, 2018 38,00 1,00
Сентябрь, 2018 39,26 1,26
Октябрь, 2018 40,86 1,60
Ноябрь, 2018 42,12 1,26
Декабрь, 2018 42,98 0,86
Январь, 2019 43,80 0,82
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question