Setting first column as x-axis in chart

Hi all

When creating a line chart of a couple of short columns of numbers in the middle of the sheet I want to set the 1st column as labels for the x-axis, a pretty simple request but I cant get Numbers to do this unless I create a new table with headers on. The trial version of Numbers worked OK. Is there a way to do this??

Thanks
Geoff

Imac, Mac OS X (10.5.2)

Posted on Apr 29, 2008 2:03 PM

Reply
5 replies

Apr 29, 2008 3:29 PM in response to Geoff Brown

Geoff,

I'm guessing that your first column is not a header column. You can add one to your table by clicking the left of three little grids near the right side of the the format bar or Inspector > Tables > Headers & Footer. Copy your labels from column B to header column A, then delete column B with the old labels. I think you will have to create a new chart. But that's easy enough and you should have labels on your x-axis.

pw

User uploaded file

May 6, 2008 1:30 PM in response to Geoff Brown

Hi PW and Jerold

PW your method sort of worked, I selected a column 'header', then copied a blank portion of that header over to my x-value column, reinserted the x values and voila, the graph had column 1 as values. I then deselected header to get rid of it from the main sheet. But a pretty messy workaround.

Jerold, I couldn't get your method to work. It didn't appear to do anything.

But either way, what I'm after is a simple check box like in Appleworks that says
'use first column as label'
What I have is 3 columns. Col 1 = x values, col 2 is y=ax+b, col 3 is y=ax+c, the most basic graph possible, but it seems that numbers cant handle it

Thanks for your time
Geoff

May 6, 2008 1:56 PM in response to Geoff Brown

Goeff,

I wouldn't draw the same conclusion about Numbers as you do. If you select your first column and format it as Text, either using the Cells Inspector or the Format Bar, then select the entire three columns and Add a Chart, the chart will use the first column as the Category axis labels and the last two columns as Value Axes data. And, you will have a Category Chart, not well suited to plotting functions.

Numbers Charts are not up to heavy duty scientific work, but they do work pretty much as advertised. By the way, for your case, you should be using a Scatter Plot, in which case Numbers will accept (demand actually) that the first column be formatted as numeric. No, you can't get lines between the points of a Scatter Plot, but that's another issue.

Thanks for your questions.

Regards,

Jerry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Setting first column as x-axis in chart

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.