Win XP HE
Excel 2002
Hi,
I have a chart with a simple y and x axis. The x axis represents dates.
In sheet1 of the spreadsheet being used, the dates are in column A and in
each cell--for the moment is a formula: = sheet2, A2, A3, etc. (where the
dates are in this format: 12/20/2004.)
The result is (obviously) the same number and format 12/20/2004 in sheet1.
When I chart, for the life of me I cannot get rid of this format in the x
axis labels--I am usually able to define the label format in tha chart
itself but, nothing I do lets me change this format.
Even when unchecking the "link to source".
There must be some kind of error here, perhaps in the "text" format, or what
not.
What can I do to be able to change this format as I desire?
Tx a lot.
S