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
|
|||
|
|||
Chart copying messes up number formats...
I have a workbook with charts that I update each month. The data used
are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#2
|
|||
|
|||
Anthos -
When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#3
|
|||
|
|||
Thanks Jon,
Indeed the "Linked to the source" is the solution to the problem. I had tried that before I had posted but when I unchecked the "Linked to the source" on the pasted worksheet, then saved and reopened, the formats were messed up. Right after I posted this message, I did try unchecking the "Linked to the source" from the original worksheet. I then copied the charts to the target and everything worked fine. My only worry that in this way the charts wouldn't update in case the data changed, were not fortunately true, so I guess no more problems. From what you're saying though, it should have worked by unlinking the pasted chart from the original one, right? Thanks again for the reply... Jon Peltier wrote in message ... Anthos - When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#4
|
|||
|
|||
Anthos -
As soon as you paste the new chart, before the source workbook is closed, unlink the formats. Smooth sailing from there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: Thanks Jon, Indeed the "Linked to the source" is the solution to the problem. I had tried that before I had posted but when I unchecked the "Linked to the source" on the pasted worksheet, then saved and reopened, the formats were messed up. Right after I posted this message, I did try unchecking the "Linked to the source" from the original worksheet. I then copied the charts to the target and everything worked fine. My only worry that in this way the charts wouldn't update in case the data changed, were not fortunately true, so I guess no more problems. From what you're saying though, it should have worked by unlinking the pasted chart from the original one, right? Thanks again for the reply... Jon Peltier wrote in message ... Anthos - When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#5
|
|||
|
|||
Yes, that works even better without messing with the original charts.
I guess I didn't do the procedure in the same order and lost the plot somewhere along. Thanks again Jon for the help. One more thing if you're not tired of me! Is there a way to unlink multiple values from the source, or does one have to manually uncheck each chart seperately? Thanks again Jon. Jon Peltier wrote in message ... Anthos - As soon as you paste the new chart, before the source workbook is closed, unlink the formats. Smooth sailing from there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: Thanks Jon, Indeed the "Linked to the source" is the solution to the problem. I had tried that before I had posted but when I unchecked the "Linked to the source" on the pasted worksheet, then saved and reopened, the formats were messed up. Right after I posted this message, I did try unchecking the "Linked to the source" from the original worksheet. I then copied the charts to the target and everything worked fine. My only worry that in this way the charts wouldn't update in case the data changed, were not fortunately true, so I guess no more problems. From what you're saying though, it should have worked by unlinking the pasted chart from the original one, right? Thanks again for the reply... Jon Peltier wrote in message ... Anthos - When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#6
|
|||
|
|||
I think I found an older answer you gave back in 2002!!!
http://groups.google.com/groups?q=ch...ftngp07&rnum=5 I'll try that Jon. Thanks Jon Peltier wrote in message ... Anthos - As soon as you paste the new chart, before the source workbook is closed, unlink the formats. Smooth sailing from there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: Thanks Jon, Indeed the "Linked to the source" is the solution to the problem. I had tried that before I had posted but when I unchecked the "Linked to the source" on the pasted worksheet, then saved and reopened, the formats were messed up. Right after I posted this message, I did try unchecking the "Linked to the source" from the original worksheet. I then copied the charts to the target and everything worked fine. My only worry that in this way the charts wouldn't update in case the data changed, were not fortunately true, so I guess no more problems. From what you're saying though, it should have worked by unlinking the pasted chart from the original one, right? Thanks again for the reply... Jon Peltier wrote in message ... Anthos - When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
#7
|
|||
|
|||
I liked that post so much, I turned it into a web page:
http://peltiertech.com/Excel/ChartsH...ChartData.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I think I found an older answer you gave back in 2002!!! http://groups.google.com/groups?q=ch...ftngp07&rnum=5 I'll try that Jon. Thanks Jon Peltier wrote in message ... Anthos - As soon as you paste the new chart, before the source workbook is closed, unlink the formats. Smooth sailing from there. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: Thanks Jon, Indeed the "Linked to the source" is the solution to the problem. I had tried that before I had posted but when I unchecked the "Linked to the source" on the pasted worksheet, then saved and reopened, the formats were messed up. Right after I posted this message, I did try unchecking the "Linked to the source" from the original worksheet. I then copied the charts to the target and everything worked fine. My only worry that in this way the charts wouldn't update in case the data changed, were not fortunately true, so I guess no more problems. From what you're saying though, it should have worked by unlinking the pasted chart from the original one, right? Thanks again for the reply... Jon Peltier wrote in message ... Anthos - When you've made a chart, and it looks fine, double click on the set of numbers that cause problems. On the Number tab of the format dialog that pops up, uncheck the Link to Source box. This locks the number format. When you are linked to source, and the source file is not open, Excel can't read the formats, and it usually just applies a general type of format. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Anthos wrote: I have a workbook with charts that I update each month. The data used are included in this workbook. When I finish updating the charts I select the sheets with the charts and use the copy sheet functions to create a copy of the charts to a new file. When I save the file everything looks ok with the number formats and everything. When I reopen the file I get another number format. If I open the original chart file, everything sorts out OK (!!!) and when I close it everything messes up again! I tried breaking the links (office 2003 links functions) when I still have open the original chart file, but still when I save/close/open the file, the number formats mess up. Any hints people? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Number formats | Andrea | Database Design | 3 | August 3rd, 2004 07:17 PM |
Multiple Number Formats | Anthony | Charts and Charting | 1 | July 27th, 2004 08:53 PM |
Chart menu visible property | Sandy V | Charts and Charting | 8 | May 17th, 2004 01:39 PM |
Embed data in graph | wrace | Charts and Charting | 5 | May 5th, 2004 04:39 AM |
reducing number of markers in XY scatter chart | Chris | Charts and Charting | 2 | September 17th, 2003 04:40 AM |