T
T
Timofey Mikhailov2018-05-04 09:16:57
excel
Timofey Mikhailov, 2018-05-04 09:16:57

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

---
As I imagine it.
There are 5 lines on the graph, which are responsible for their year.
Next, I need to not just take data, but subtract from the previous value.
Those. for the period [from January 2018 to February 2018] the value will be 28.00 - 26.00 = 2
Further:
- 29.60 - 28.00 = 1.60
- 32.10 - 29.60 = 2.50
- 33, 00 - 32.10 = 0.90
I hope I'm being more or less clear.
---
How this can be done - I do not know yet. Probably, through VBA you can definitely write something. But suddenly there are standard methods?
PS Or do I need a separate table in which the difference will be recorded, and already build a graph on it?
---
Prompt. I don't know what to think.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
L
longclaps, 2018-05-04
@JimmiJanger

Or do I need a separate table in which the difference will be recorded, and already build a graph on it?

Need, my timid friend.

A
alexalexes, 2018-05-04
@alexalexes

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 question

Ask a Question

731 491 924 answers to any question