3905 Views 3 Replies Latest reply: May 14, 2010 7:27 AM by jaxjason
Her's what I've figured out so far (using the updated Numbers that just came out today):
I can make a scatter chart if I put the dates into the second column and the y values into the third column. If I put the dates into the leftmost gray column, I can't select them for my chart.
One strange thing I haven't been able to figure out is how to format the x axis. I get what look to be time values (around 200 million for Jan. 1, 2010) as x axis values, but there's no way that i can see to make them back into dates. But the graph points definitely spread across the x axis in proportion to the dates I've entered.
ok, i was able to 'kinda' get it to work (not the labelling, but the scatter plot). It seems you have to select the date column first when selecting data, then drag over to the columns of plotted data and it -might- recognize the dates as the x axis. it took me a good 5 minutes playing to get it to go right.
I also had to check the "Share X values" option under the gear button.
as for the labels, it has a "Number format" and a "Same as source", but if you select same as source, it doesn't give you any choices but plain number for formatting. Same as source doesn't work at all right now for dates.
We both need to submit tickets with apple.com\feedback to let them know. I noticed other little fixes that were not documented in the 1.1 update that people had been submitting tickets on the past few weeks.