If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
linked Excel charts don't match formatting in original
I have one spreadsheet in which I created charts linked to worksheets in the
same file. These charts I have exported (i.e. copied into another file). When I open that other file without having the original file with the data open, the labels on the charts don't reflect the number formatting that was selected for them: .09 instead of 9%. Any help would be appreciated as I can't figure out how to fix this. For instance, is there a way to break the link to freeze a certain look of the charts? Thanks, Stefan. |
#2
|
|||
|
|||
You could copy and paste the poicture rather than the link. If you're pasting into another iscorsoft programme, use Paste Special!Picture. -- fernmp ------------------------------------------------------------------------ fernmp's Profile: http://www.excelforum.com/member.php...o&userid=16021 View this thread: http://www.excelforum.com/showthread...hreadid=274925 |
#3
|
|||
|
|||
The formats link to the source, if the source file is open. If Excel can't see the
source data formatting, it uses the General format. To lock in the format, reopen the source file, double click on the labels or axis with the numbers, click on the Number tab, and uncheck the Linked to Source box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stefan Gildemeister wrote: I have one spreadsheet in which I created charts linked to worksheets in the same file. These charts I have exported (i.e. copied into another file). When I open that other file without having the original file with the data open, the labels on the charts don't reflect the number formatting that was selected for them: .09 instead of 9%. Any help would be appreciated as I can't figure out how to fix this. For instance, is there a way to break the link to freeze a certain look of the charts? Thanks, Stefan. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing Source File of Linked Excel Charts | Brad Bendecl | Powerpoint | 3 | August 4th, 2004 08:44 AM |
Formatting Linked Excel Tables | Tammie | Tables | 7 | June 10th, 2004 10:25 AM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
Linked Charts in Excel 2000 | Don R | Charts and Charting | 2 | January 18th, 2004 07:01 PM |
Excel charts in print preview distorted. | George Wilson | Charts and Charting | 1 | January 16th, 2004 02:37 PM |