I'm quite new to Numbers (and spreadsheets programs in general) but I need to create a simple line graph based of a spreadsheet but for some reason Numbers is not making the lines of the graph even though the data is there.
What I'm doing wrong?
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.
Sign up to join this communityI'm quite new to Numbers (and spreadsheets programs in general) but I need to create a simple line graph based of a spreadsheet but for some reason Numbers is not making the lines of the graph even though the data is there.
What I'm doing wrong?
It is a bit hard to say from the picture you have shared but you may not be doing anything wrong at all. Here is a chart I created with similar data with yours.
I just selected the numbers to be charted (but did not select either the header row or the header column) and then clicked on Chart in Numbers toolbar at the top and selected the icon representing the 2D line chart.
Numbers behave in a weird fashion sometimes in creating charts in my experience. This happens to me occasionally even when I am creating simple charts. When this happens, I create a new file, copy the data only to the new file and create a new chart usually using the same steps. Those steps that have failed in my first trial usually work in the second trial!
To plot in Numbers you need to select two columns and then insert a chart. Makes sure the chart type is a line plot or scatter plot. Then the plot should appear. If not check your axis and see if they are scaled properly. It sounds confusing but it's really easy. I've made many plots using Numbers so if you need additional help just add a comment. I'll try to help.
I replicated your table and for me, the chart just happened automagically. I had the entire table selected, rather than any specific rows/columns/cells.
Maybe you should also check if the data format of the cells is set to numbers, and not text or something else? The way it is left-aligned makes me kind of suspicious of that.