Chart Over time

[naquinn]

Hello everyone,

Hope someone can help me with this.

I'm trying to make a chart from a list of trading results.

I have a log sheet in which I log each trade. Each trade has a date in a column and also the result in dollars.

I can do a simple chart that shows the dollars on the Y axis and the whole number of trades (174) on the X axis.

This looks ok, but I would like to show how my trades have be doing over time. The problem is that some of the trades have the same dates.

Can anyone think of a way that I can show the trade performance between the first and last date in the list? I've managed to create a cell that calculates the number of days I have been trading, by taking the first date in the list and counting the number of days using the =NOW() function. I just can't seem to work it out!

Hope that's kind of clear.....

Any help, is very very gratefully received!

Thanks in advance

nick (London)

 

[trevor101]

I'm not clear on what you are trying to achieve.
Why do you think you need to use Now()? this is volatile and will show the current date & time, and so will continually update everytime you change something or save the file.
In Excel if you subtract two dates and format the result as a number you will get the number of days between the two dates [you can also use datedif(start date, end date,"d") for the number of days, change "d" to "m" for months & "y" for years.
In Excel you can just plot the results straight to a graph, it should show the dates as dates, if it doesn't, format the axis and choose days as the base unit.