Graph Help

[NealGowdy11]

Good afternoon all,

I have been struggling with this all day.. I know there is probably a simple solution but I just cant crack it!

I have the following data (may need to be re-arrange i know):

For the example above, additionally:
Total project budget = $100000
Current spend = $45000

End of each month the PM runs off a report.

Id like a cumulative graph that shows dates on x axis, (keeping the date each month), cost on the y axis.
then line graphs for current spend, earned value and estimate at completion.

Hope all that makes sense.

Thank you in advance for any help.

N

 

[earthworm]

what is the cost for each month / day being incurred ?

 

[earthworm]

You can create graph from below data

X Axis	Y Axis	Spend	%
Jan-2021	25000	25000	100%
Feb-2021	25000	20000	80%
Mar-2021	25000		0%
Apr-2021	25000		0%

 

[NealGowdy11]

Thank you works pefectly