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? 
How create a graph of profit over time
graphnumbers
Related Solutions
If you want a line graph with 2 y-axes. You to insert->Chart-> 2-Axis. Put in your data. One of the sets will be a line the others a bar. The way to fix that is: Select the one that is a bar then to go to the Inspector-> Chart-> Series. It will say series type-> select that and change it from bar to line. Right below that it says plot on: There you can determine if you want that line to be plotted on y(1) or y(2).
Have a look at the following Software for visualizing X,Y,Z Data as a 3D Scatter and 3D Surface graph:
These are for the most part scientific tools, so don't expect any friendly UI. There are some other tools for *nix and Windows, but the you have to use Wine, Crossover or some VM to use it.
There is also 'ChartDirector' - a Script for PHP, ASP, JSP etc. for usage directly in HTML.
But I am still wondering: if all you want to do is put in some Text on a chart with 3 Axis, wouldn't it be easier for you to draw the graph by hand?
You could Illustrator, InkScape, Sketch or Gliffy
Related Question
- Is the Health App Graph Logarithmic
- Mac – How to plot two data streams in Numbers as a graph
- Display point values on numbers graph
- How to change a Numbers graph x axis to go from the lowest value to the highest value
- Move equation of plot on graph in Pages
- MacOS – How to draw a mathematical graph on mac
- How to add colors for Charts in Numbers v6
- Numbers not creating a line graph
Best Answer
To create a graph of profit over time, you need data over time. Spreadsheets can only plot graphs of data present in a table, or interpolated between. That means you need a table containing rows for each time point you want plotted, not just the current value.
Numbers can import ‘delimited or fixed-width text files’. If you can find a source for the data you need over time, you can import this into Numbers and plot the data over time.
Create one row for each point in time over a contiguous time period with regular interval and use a line graph, or plot using a scatter graph for non-contiguous/non-regular time (other types cannot be used, see Time as x-axis in chart with Apple Numbers).