Cash flow......

[James Perry]

Hi guys...

I need help with a Line Chart/Graph Problem. I have following problem.

I want to represent cash flow at the end of the each month.

Below is my data.

For example at the end of month-2, net cash flow is (165,070) But suddenly a payment comes thru from a client.

So finally becomes my cash flow at the end of month-2 is (76,482).

So there are 2 amounts for month-2 (X axis).

Likewise....how do I do a graph???


(79,630) Month-1

(165,070) Month-2

(76,482) Month-2

(128,422) Month-3

(36,608) Month-3

(97,848) Month-4

(41,836) Month-4

(78,326) Month-5

(12,258) Month-5

(86,958) Month-6

(47,338) Month-6

55,718 Month-7


Thank u very much.

 

[DaveTurton]

Would an 'XY Scatter' chart with data points connected by lines suffice?


Using the following:

[pre]

Month	Cash
1	-79,630
2	-165,070
2	-76,482
3	-128,422
3	-36,608
4	-97,848
4	-41,836
5	-78,326
5	-12,258
6	-86,958
6	-47,338
7	55,718

[/pre]

 

[James Perry]

Many thanX Dave.....stay blessed.