software

(this is Excel 2003)

We have a graph in BookA.
When I open BookA the format of the dates on the X axis are
01-Jan-2006.
When I use Editgt;Linksgt;Break Link to BookB, the dates on the graph
revert to a general integer: 38718

Any one ever encountered this befo any ideas how to preserve the
format?

Any help greatly appreciated,
JasonHi,

Not sure whether you can preserve the formatting. If you check the data
series after breaking the link the numeric values of the dates is what
has been transfered not the formatted ones.

To fix it you need to double click the axis and set the Number format to
be the same as the cells where the data originally came from.

Cheers
Andy

WhytheQ wrote:
gt; (this is Excel 2003)
gt;
gt; We have a graph in BookA.
gt; When I open BookA the format of the dates on the X axis are
gt; 01-Jan-2006.
gt; When I use Editgt;Linksgt;Break Link to BookB, the dates on the graph
gt; revert to a general integer: 38718
gt;
gt; Any one ever encountered this befo any ideas how to preserve the
gt; format?
gt;
gt; Any help greatly appreciated,
gt; Jason
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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.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
PeltierTech.com
_______quot;WhytheQquot; gt; wrote in message oups.com...
gt; thanks Andy: double clicking the axis and re-formatting the numbers as
gt; dates is what we are presently doing.
gt; I was hoping that there would be a way around having to do this.
gt;
gt; seems strange to me that formatting can be dependent on links.
gt;
gt; cheers
gt; Jason.
gt;
Thanks very much
JOK - the unchecking of quot;Linked to Sourcequot; box worked fine for
preserving the axis format, but it doesn't seem to work for the graphs
legend i.e we have three lines on a graph for April,May amp; June
respectively, but if the source file is closed then the legend changes
to 38808,38838 amp; 38869 !!!

Anybody got any ideas?

Any help greatly appreciated.
Jason
WhytheQ wrote:

gt; Thanks very much
gt; J