chart formating

  • Thread starter Thread starter briank
  • Start date Start date
B

briank

My simple chart project has turned ugly.
I have several charts linked from different files into my
active spreadsheet. The x axis on all of these linked
charts are date fields. However, on all of these linked
charts a general number format is showing up not a date
format. Is there anyway to have these numbers defaulted
to a dated format?
 
I've had problems with dates looking like numbers on axes
in the past, and to get them to look like dates I had to
go into the axis properties (right-click the axis or one
of the numbers on the axis, then click on "format axis")
and select a date format on the "Number" tab. I don't
think you can get this to happen by default, but I'm no
expert (just a regular user!) :-).
 
If the number format is linked to the data, and the data is in a closed
file, Excel can't read the format, and you get stuck with General. If
you uncheck the Linked to Source box in the Number tab of the Format
dialog while the source file is open, it will remember the format.
Otherwise you have to select an appropriate format as Joy describes.

- Jon
 
Back
Top