Creating a Line Graph

[jcountry22]

I need assistance with creating a trending line graph.
Example below.
The Totals are rollforward totals.
Project 1 had $13k cost for Jan, Then $0 additional cost for Feb so cost remainded the same. March it incurred additional cost of $21k, etc.

I'm trying to create a trend graph to show the increase Month over Month on each project.

Project #	Month	Total
1	Jan-24​	13,347.90
2	Jan-24​	41,170.00
3	Jan-24​	-
1	Feb-24​	13,347.90
2	Feb-24​	74,002.50
3	Feb-24​	-
1	Mar-24​	34,410.40
2	Mar-24​	86,050.00
3	Mar-24​	-
1	Apr-24​	43,667.90
2	Apr-24​	86,050.00
3	Apr-24​	10,138.14
1	May-24​	43,667.90
2	May-24​	86,050.00
3	May-24​	10,138.14
1	Jun-24​	43,667.90
2	Jun-24​	86,050.00
3	Jun-24​	10,138.14

 

[awoohaw]

Try this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Project #	Month	Total			Jan-24	Feb-24	Mar-24	Apr-24	May-24	Jun-24		Monthly Accumulating Project Totals
2	1	Jan-24	13347.90		1	13,347.90	26,695.80	61,106.20	104,774.10	148,442.00	192,109.90
3	2	Jan-24	41170.00		2	41,170.00	115,172.50	201,222.50	287,272.50	373,322.50	459,372.50
4	3	Jan-24	0.00		3	0.00	0.00	0.00	10,138.14	20,276.28	30,414.42
5	1	Feb-24	13347.90
6	2	Feb-24	74002.50
7	3	Feb-24	0.00
8	1	Mar-24	34410.40
9	2	Mar-24	86050.00
10	3	Mar-24	0.00
11	1	Apr-24	43667.90
12	2	Apr-24	86050.00
13	3	Apr-24	10138.14
14	1	May-24	43667.90
15	2	May-24	86050.00
16	3	May-24	10138.14
17	1	Jun-24	43667.90
18	2	Jun-24	86050.00
19	3	Jun-24	10138.14
Sheet4

Cell Formulas
Range	Formula
F1:K1	F1	=TRANSPOSE(UNIQUE(SORT(B2:B19,1,1)))
E2:E4	E2	=UNIQUE(SORT(A2:A19,1,1))
F2:K4	F2	=SUMIFS($C$2:$C$19,$B$2:$B$19,"<="&F$1,$A$2:$A$19,$E2)
Dynamic array formulas.

Hope this helps.

 

[jcountry22]

It does, but on a larger scale. I have 50 projects..


How do you get Projects to show on the Y axis on the Far left (where numbers currently are)
Keep Months at the bottom.
Have values incorporated from the other Y-axis on the right?

 

[awoohaw]

Do you mean having the LEGEND shown on the left?

Not sure Line Graphs would be the best to show for such a large number of series to map. It will look like spaghetti.

Here is where the legend is moved:

(this is in Excel 365, so unsure how your chart tools appear, but you can select the chart and press CNTL-1 and open the chart formatting dialog.
Click the 'arrow' beside "Chart Options" and select LEGEND. (Please update your profile so the forum knows the excel version you use).

 

[awoohaw]

Sorry, I could not add this before the post editing time expired. But here is how you can add BAR charts with the months as series added to give you totals.
This would be expandable to show all the projects without spaghetti like lines.
Please note the custom number format so the X axis is not so busy (but this would be your prerogative).

The downside to this chart is that the time perspective the line chart gives is severely affected.

But with spaghetti lines you may not have a clear idea of what line goes with which project.

You'll have to weigh the options.