Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
(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 EditLinksBreak 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, Jason |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
Hi,
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: (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 EditLinksBreak 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, Jason -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
Thanks very much
J |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Break links automatically changes graph's date format
OK - the unchecking of "Linked to Source" 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 & June respectively, but if the source file is closed then the legend changes to 38808,38838 & 38869 !!! Anybody got any ideas? Any help greatly appreciated. Jason WhytheQ wrote: Thanks very much J |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format trouble | Excel Discussion (Misc queries) | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
Change general format to US date format | Excel Discussion (Misc queries) | |||
imported impromtu report date issue - fix by format or formula | Excel Discussion (Misc queries) | |||
prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) |