Sample Header Ad - 728x90

How create a graph of profit over time

0 votes
1 answer
297 views
I have created a spreadsheet on numbers to track profit/loss of cryptocurrency investments. I have taken the data for the current value of the cryptocurrency using stock quote so it updates every few minutes. I have a total profit amount at the bottom of the spreadsheet that changes as the figures do. I’d like to create a line graph that shows the profit going up and down over time. I’m not sure how to make the x axis correspond to a date and how to link this with the profit, I don’t really want it to update every few minutes as the figures do but possibly once daily. Can anyone help please? enter image description here
Asked by Sarah (1 rep)
Apr 29, 2021, 06:45 PM
Last activity: May 29, 2021, 09:03 PM