Trend graph for analysis

Question :
I have used a trend graph for the plan and actual sale values.  I am not getting the graph as required. How to do it?

Solution:

For trend graph we need to use the cumulative value rather than monthly value to get the desired graphs.

The cumulative values will represents the progressive value to achieve at different point of time.

	Plan	Cplan	Actual	Cactual
Jan	10	10	10	10
Feb	12	22	13	23
Mar	12	34	14	37
Apr	12	46	11	48
May	18	64	23	71
Jun	20	84	30	101
Jul	20	104	20	121
Aug	20	124	19	140
Sep	20	144	15	155
Oct	20	164	18	173
Nov	20	184	22	195
Dec	20	204	30	225