When the chart is formatted properly (the source workbook is open and still
linked), format the axis. On the Number tab, uncheck the linked to Source
box. This preserves the selected format when the source goes away.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"WhytheQ" wrote in message
oups.com...
thanks Andy: double clicking the axis and re-formatting the numbers as
dates is what we are presently doing.
I was hoping that there would be a way around having to do this.

seems strange to me that formatting can be dependent on links.

cheers
Jason.