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?
Numbers not creating a line graph
iworknumbers
Related Solutions
I’ve noticed a button you don’t have. What version of Numbers do you have? (I have 09)
Look at this:
That swaps the columns in the graph (exactly like you describe). I’m not really very good at Numbers.
Do you have that? One thing I’ve done, is used the price as a “column” but maybe that’s why you don’t have it?
My graphic looks awesome (sarcasm)…
(btw I hadn’t saved it and had to do it again)
It appears that the Data Symbols series preference is not a part of the styles. Why can't you select all of the charts when you are finished with them (by Command clicking or Command + Shift dragging) and then changing the data point styling of all of them at one time?
Related Question
- Connecting MySQL DB to Apple iWork Numbers
- How to ignore units in Numbers
- IPad – Cannot update Numbers document on iPad
- Numbers – continuous line connecting gapped data
- IOS – In numbers or pages for ios, Is it possible to force a trend line to start at (0,0)
- Programmatically convert formulas to their values in Numbers
- In Numbers make Y axes show smaller values
- ICloud – Unable to collaborate on a Numbers spreadsheet
Best Answer
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!