Numbers CHART help: Adjusting X and Y axis
I'm making a chart in numbers for a school project (used to use excel but with my recent purchase of my macbook pro I decided to lose Microsoft office and just use iWork 08.
I have entered 4 columns of information in a spreadsheet with names above each column. My first column needs to be my X-axis while columns 2, 3, 4 need to be the information that is on my chart (line chart) and the Y-axis.
When I highlight all 4 columns and make a line graph it makes 4 lines (I only need 3) and the Y-axis is correct but there is no numbers for my X-axis. I then tried just highlighting columns 2, 3, 4 and it worked great.... I got the 3 lines I needed in my line graph, but then I had no X-axis again and the numbers I need for the X-axis are in my first column.
Not sure how I can incorporate just the 3 columns to actually put on the graph then get the numbers for the X-axis using that first column.
I hope I explained myself clearly (probably not) so please ask any questions if you have any. Thanks in advance!
I have entered 4 columns of information in a spreadsheet with names above each column. My first column needs to be my X-axis while columns 2, 3, 4 need to be the information that is on my chart (line chart) and the Y-axis.
When I highlight all 4 columns and make a line graph it makes 4 lines (I only need 3) and the Y-axis is correct but there is no numbers for my X-axis. I then tried just highlighting columns 2, 3, 4 and it worked great.... I got the 3 lines I needed in my line graph, but then I had no X-axis again and the numbers I need for the X-axis are in my first column.
Not sure how I can incorporate just the 3 columns to actually put on the graph then get the numbers for the X-axis using that first column.
I hope I explained myself clearly (probably not) so please ask any questions if you have any. Thanks in advance!
Macbook Pro, Mac OS X (10.5.2)
