Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Partial Lost Formatting in Linked File?
I have a macro process that generates charts in a series of individual
workbooks and copies each chart sheet from that workbook to a single workbook. This results in a workbook containing up to sixty charts, which I then mail out. Obviously, once mailed, the external links are no longer available. Not a problem, except for one thing... The X-axis is a date range. In the original copy (residing in the same workbook as the data), the axis looks good, and the mouseover text on all series works just fine - I see, for instance, 'Series "X" Point "10-Mar-06" Value: 0.033' When I look at the same point in the dissociated copy, the X-axis still looks just fine, but the mouseover text renders the date as a number, i.e., 'Series "X" Point "38786" Value: 0.033'. Short of transcribing all of the data along with the charts, is there any way I can persuade the copied chart to express the X-axis value correctly in the mouseover? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i renamed a file i needed and lost the info how do i get it back? | New Users to Excel | |||
File Error - Data May Be Lost message after Access export | Excel Discussion (Misc queries) | |||
linked values not displayed unless source file open | Excel Discussion (Misc queries) | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |