Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy chart to another worksheet - crashes
Hello I'm trying to copy a chart from one worksheet to another. Once I
copy the chart and try to change the source data and I get the message "No more fonts may be applied to this workbook" After hitting Ok several times the chart options windows appears. If I copy the chart several times excel crashes. So how do I copy a chart to another sheet? what I'm I doing wrong |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy chart to another worksheet - crashes
Copy the entire sheet, including chart and data. Change the data, and the
chart will update. For the 'No new fonts' error, see this: http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wanna Learn" wrote in message ... Hello I'm trying to copy a chart from one worksheet to another. Once I copy the chart and try to change the source data and I get the message "No more fonts may be applied to this workbook" After hitting Ok several times the chart options windows appears. If I copy the chart several times excel crashes. So how do I copy a chart to another sheet? what I'm I doing wrong |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy chart to another worksheet - crashes
Hello,
When I copy or move a sheet which contains a chart by right clicking the sheet and selecting Move/Copy, it only seems to copy the entire sheet and chart when I move/copy to a new workbook. If I copy/move to an existing (Open) workbook the new worksheet contains an empty chart and the source data shows REF!. In Office 2003 a sheet can be moved to either a new workbook or an existing workbook (as long as it is also open). In Office 2003 the entire sheet and chart are copied and the source data automatically points to the new sheet. Is this a bug in Excel 2007 that will be fixed? Thanks, Helen "Jon Peltier" wrote: Copy the entire sheet, including chart and data. Change the data, and the chart will update. For the 'No new fonts' error, see this: http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wanna Learn" wrote in message ... Hello I'm trying to copy a chart from one worksheet to another. Once I copy the chart and try to change the source data and I get the message "No more fonts may be applied to this workbook" After hitting Ok several times the chart options windows appears. If I copy the chart several times excel crashes. So how do I copy a chart to another sheet? what I'm I doing wrong |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy chart to another worksheet - crashes
Well, that's a strange one. Looks like a bug, and I won't place odds on
getting it fixed. In Office 2007 SP1: If you copy or move the sheet with data and a chart to another workbook, if the new workbook already has a sheet with the same name as the copied sheet, the copied sheet is renamed from, say, Sheet1 to Sheet1 (1). The chart still references Sheet1, however, without updating to the new name of its parent sheet. So if Sheet1 doesn't have data in the source range, the chart appears empty. If the target workbook has no sheet with the same name, the copy of the sheet with the chart looks like it occurred correctly. In Office 2003 and earlier versions: copying or pasting to another workbook results in a sheet with a new name if necessary, and the chart always linking to its parent sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "HVR" wrote in message ... Hello, When I copy or move a sheet which contains a chart by right clicking the sheet and selecting Move/Copy, it only seems to copy the entire sheet and chart when I move/copy to a new workbook. If I copy/move to an existing (Open) workbook the new worksheet contains an empty chart and the source data shows REF!. In Office 2003 a sheet can be moved to either a new workbook or an existing workbook (as long as it is also open). In Office 2003 the entire sheet and chart are copied and the source data automatically points to the new sheet. Is this a bug in Excel 2007 that will be fixed? Thanks, Helen "Jon Peltier" wrote: Copy the entire sheet, including chart and data. Change the data, and the chart will update. For the 'No new fonts' error, see this: http://peltiertech.com/Excel/Charts/FixFonts.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Wanna Learn" wrote in message ... Hello I'm trying to copy a chart from one worksheet to another. Once I copy the chart and try to change the source data and I get the message "No more fonts may be applied to this workbook" After hitting Ok several times the chart options windows appears. If I copy the chart several times excel crashes. So how do I copy a chart to another sheet? what I'm I doing wrong |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel crashes worksheet with VBA and Word with embedded worksheet | Excel Discussion (Misc queries) | |||
anyway to copy the chart format to another worksheet | Excel Discussion (Misc queries) | |||
Excel crashes dragging a chart | Charts and Charting in Excel | |||
Excel Worksheet crashes when changes are made. | Excel Worksheet Functions | |||
Copy row, Insert>Copied>Cells crashes Excel | Excel Discussion (Misc queries) |