James Lockie wrote:
On 10/3/2005 5:46 PM Adam Pearson spoke:
James Lockie wrote:
On 5/17/2005 3:07 AM Mixu Lauronen spoke:
3. Column a contains dates and I only want the day of the week in
my chart.
You have to change the column display format for that.
Select the column, choose Format -> Cells. In Numbers leaf there
are lots of different formats. Choose Date, change format code to
NNNN. That should do the trick.
I changed the column format in a new chart to date format and it
still displays as a number.
I put the file up on http://www.lockie.ca/test/t.sxc
You have to enter DDD in the "Format Code/User Defined" custom
formatting to get a day displayed (make sure Date is selected in
"Category").
I can get the column to display right but the chart is always a
number. :-(
Once your data table is formatted correctly, have you tried ticking the
box "source format" in the x-axis dialog box? Or, use a user-defined
date in the x-axis dialog box, "ddd".
Adam
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
