Line Graph Of Profit Against Time

**camikhazi** · 09-07-2015, 09:22 AM

Hi All,

I have written a fairly simple excel (2013) program that calculates and displays some poker stats.

This includes displaying your total profit in a single cell.

This value changes as you input your different sessions profits/loss'.

Is there a way to graph this profit value against the date? I.e. i need a graph that updates every time i update my profit and charts it against the current date.

Thanks,

Cam

**Kaper** · 09-07-2015, 09:37 AM

Not really that way you described it. The data for each date shal be stored somewhere in the workbook and then can of course be plotted. If it is just one cell which changes daily or time to time , you can only plot it's curent value (not very informative graph :-P)

As for automatic storing date and value - it can be done with simple macro for Worksheet_Change event.

**camikhazi** · 09-07-2015, 09:53 AM

Thanks for your reply,

Could you tell me how i would set up such a macro?

Cam

**Kaper** · 09-07-2015, 10:42 AM

Worksheet_Change is keyword to our search engine http://www.excelforum.com/search.php :-)

The code could be as simple as that:

Please Login or Register  to view this content.

There are 2 sheets Archive one and the one with data. lets say value is in C3 of data and in archive in columns A and B is excel table (Ctrl+T) with dates and values.
As these are in Table, the graph is updated every time new value appears in table. and it appears when above code is executed.
This code is in your sheet data code (right click on tab and choose "display code")
Try this

PS. if changes are more frequent (more often than daily) I'd personally change graph type to scatterplot.