Hey, thanks for presenting this. It got me on the right track. Using your information, I figured out that if you change your label column to a 'text' data type rather than "number" or "automatic", it formats correctly! Appreciate the help, that was a really frustrating formatting experience!
Oh my goodness ! Thank you so much ! I had never had to work with Numbers before, so you can imagine my frustration, but this was so helpful ! Thanks so much again ! :)
You want to use the scatter graph option, not the line graph. Then you can select both year and bikes columns, and the plot will appear as expected with year along X and bikes along Y. You need to connect the points of the graph though (default is scatter), that is done using the inspector.
Every "Table" in Numbers can have a Title-Column and Title-Row. If you "forget" to create them, Numbers is confused about axis. There are 2 buttons to create this. You have to pay attention at 0:28, where he creates the Chart. As you can clearly see the grey row on top and the first column, this table has a title-column and row (see the buttons under "Inspector"), but stutclass just puts all his data in the dataarea. So propper doing here would be. A1 here goes the Year and the A-column is filled with the years. Next: B1 - here comes the Word "Bikes" and the Data - of course - in the B-column. Now the Chart should work almost from the spot.
or, using this example, simply move the Year data column over to the left, now it is in the shaded header column & move the Bike data up to the shaded header row. Select the data, select a chart.
So, according to Matt Baier, below and years ago, if Stutz had put "Year" in A1 and "Bikes" in B1, the chart would have been created as he wanted it to be in the first place, without the work-around. Am I reading Matt right?
you put year at the top in the A column in cell 1, then the years listed below that starting with Cell A2, in column B the number of bikes and your chart will be right and you won't have to do this.
Oh, got it! See @Matthias Baier 's comment below: If you watch the beginning of the video carefully, stutzclass doesn't actually use the *1st* row and the *1st* column which are greyed. I made the same mistake and so that's why I had to go to Google to figure out how all you smart people did this. Thanks everyone!
How about 2 lines in one graph but each line has a differ y axis value similar to how in his video the graph first looked like. One line has values on the left and the other line has values on the right. How is that done? thanks
You save me, thanks. Clear presentation. I have a question as well. I added a trend line and it came out in blue. No problem, but can it's color be changed? I want to add my problem is also making an equation from a few X, Y data points. I did manage to get a linear slope figured out and made an equation out that seems to work y=m*x-k. This was luck on my part. If you know where to find directions on forming an equation it would be wonderful! Again - Thanks!!
Okay, so my problem is - how do you transfer the data into a graph to begin with? I see how you are doing it, but it doesn't work for me. Do you use "table" ? I don't get it. I don't understand why you can't just go to "graph" and enter the data somewhere and have it turn into a damn graph. I can't get rid of the stupid sample graph.
Great video, just thinking though, why is it so hard to do this simple task? Think apple should really sort this out tbh. Huge c*ck up in my opinion...
Oh dear! Wrong sort of graph for the data! This is a category chart, not a time series, the lines are not trend lines, the saving grace here is that the time labels are equally spaced, which leads people down the path to hell if the time labels they are using are not. It should be a bar or column chart. Done with the express knowledge that time is not displayed properly - there is no proper time axis! If you want to display a time series trend then the x-axis should be a proper linearly spaced time axis. AN X-Y SCATTER CHART is how you do this. Numbers is fundamentally brain damaged at doing this, to the point of being wantonly misleading to the point of screaming frustration.
this was EXTREMELY helpful, especially when I'm attempting to make a chart hours before my project is due lolol thank you! god bless you haha
Hey, thanks for presenting this. It got me on the right track. Using your information, I figured out that if you change your label column to a 'text' data type rather than "number" or "automatic", it formats correctly! Appreciate the help, that was a really frustrating formatting experience!
seriously THANK YOU you saved my life. I had to do a v vs t graph for physics and this was my first time not using excel!!
You definitely don't need to label the axis manually, the program can pick up the labels from the headers and/or rows if you do it right.
Oh my goodness ! Thank you so much ! I had never had to work with Numbers before, so you can imagine my frustration, but this was so helpful ! Thanks so much again ! :)
Why is there no straightforward functionality to just select both columns and generate the x-y graph automatically???? So frustrating.
You want to use the scatter graph option, not the line graph. Then you can select both year and bikes columns, and the plot will appear as expected with year along X and bikes along Y. You need to connect the points of the graph though (default is scatter), that is done using the inspector.
"Heinous". Thank you for bringing that word back to my regular vocabulary.
THANK YOU! Spent an hour trying to insert dates.
Every "Table" in Numbers can have a Title-Column and Title-Row. If you "forget" to create them, Numbers is confused about axis. There are 2 buttons to create this. You have to pay attention at 0:28, where he creates the Chart.
As you can clearly see the grey row on top and the first column, this table has a title-column and row (see the buttons under "Inspector"), but stutclass just puts all his data in the dataarea. So propper doing here would be. A1 here goes the Year and the A-column is filled with the years. Next: B1 - here comes the Word "Bikes" and the Data - of course - in the B-column. Now the Chart should work almost from the spot.
Super helpful. Brief and concise.
or, using this example, simply move the Year data column over to the left, now it is in the shaded header column & move the Bike data up to the shaded header row. Select the data, select a chart.
So, according to Matt Baier, below and years ago, if Stutz had put "Year" in A1 and "Bikes" in B1, the chart would have been created as he wanted it to be in the first place, without the work-around. Am I reading Matt right?
Thanks - really great
super helpful, exactly what my dumb brain needed thanks! :)
This is so awesome! Thank you so much!!!
brilliant video! really helped out, cheers
Simple and very good explained.
THANK YOU SO MUCH!
Yay! Thanks dude saved my life!
you put year at the top in the A column in cell 1, then the years listed below that starting with Cell A2, in column B the number of bikes and your chart will be right and you won't have to do this.
That's what he did in the video and it didn't work right away. What are we missing?
Oh, got it! See @Matthias Baier 's comment below: If you watch the beginning of the video carefully, stutzclass doesn't actually use the *1st* row and the *1st* column which are greyed. I made the same mistake and so that's why I had to go to Google to figure out how all you smart people did this.
Thanks everyone!
Thank you. Very helpful information.
How about 2 lines in one graph but each line has a differ y axis value similar to how in his video the graph first looked like. One line has values on the left and the other line has values on the right. How is that done? thanks
Very helpful, thank you :)
Thanks for tutorial. What if the data is a lot, like 500 data and I want to change the "untitled 1" ...... "untitled 500" , to microseconds?
nice and simple -thanks
You're great!
You save me, thanks. Clear presentation. I have a question as well. I added a trend line and it came out in blue. No problem, but can it's color be changed?
I want to add my problem is also making an equation from a few X, Y data points. I did manage to get a linear slope figured out and made an equation out that seems to work y=m*x-k. This was luck on my part. If you know where to find directions on forming an equation it would be wonderful!
Again - Thanks!!
Okay, so my problem is - how do you transfer the data into a graph to begin with? I see how you are doing it, but it doesn't work for me. Do you use "table" ? I don't get it. I don't understand why you can't just go to "graph" and enter the data somewhere and have it turn into a damn graph. I can't get rid of the stupid sample graph.
thank you so much!!!
Thanks!!!
Great video, just thinking though, why is it so hard to do this simple task? Think apple should really sort this out tbh. Huge c*ck up in my opinion...
Hi there, thanks for your video. Does anybody know how to draw three lines? This means I have three columns for y values?
i just cant do this
thx :D
was it me, or was the screen black???
thx
Does anyone else thinks he sounds like Bill Murray? :D
Use a different app, such as R, to plot the graph
He's in my school!
i meant like: NO, FOR REAL not like
Thanks for sharing. The fact that Numbers can't take simple data and make a line graph is disappointing & it should be embarrassing to apple.
Hellooooooooooooo!
@MrAwsomeguy2000:
same.
NO FOR REAL
Oh dear! Wrong sort of graph for the data! This is a category chart, not a time series, the lines are not trend lines, the saving grace here is that the time labels are equally spaced, which leads people down the path to hell if the time labels they are using are not. It should be a bar or column chart. Done with the express knowledge that time is not displayed properly - there is no proper time axis! If you want to display a time series trend then the x-axis should be a proper linearly spaced time axis. AN X-Y SCATTER CHART is how you do this. Numbers is fundamentally brain damaged at doing this, to the point of being wantonly misleading to the point of screaming frustration.
not like not for real like
Simple and very good explained.