Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy Excel Chart from one book to other without links...
Hello All, I wanted to know if there is a way that I can copy the chart from one workbook to other with no external link. Say, I have a chart plotting data from Sheet 1 (A1:B100,B1:B100 of Sheet 1) and want to copy the chart to the next sheet with data at Sheet 2(A1:100,B1:B100 of Sheet 2) Thanks, Venkith -- venkith ------------------------------------------------------------------------ venkith's Profile: http://www.excelforum.com/member.php...o&userid=37294 View this thread: http://www.excelforum.com/showthread...hreadid=570074 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy Excel Chart from one book to other without links...
If it's an embedded chart, copy the chart's parent worksheet to the new
workbook, then paste the new data on top of the copied data. If it's a chart sheet, move (don't copy) the chart sheet and the source data sheet to the new workbook, then close the original workbook without saving changes (so the saved version still contains the moved, i.e., removed, sheets), then paste the new data on top of the copied data sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "venkith" wrote in message ... Hello All, I wanted to know if there is a way that I can copy the chart from one workbook to other with no external link. Say, I have a chart plotting data from Sheet 1 (A1:B100,B1:B100 of Sheet 1) and want to copy the chart to the next sheet with data at Sheet 2(A1:100,B1:B100 of Sheet 2) Thanks, Venkith -- venkith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Needing to re-order a datatable display on an Excel chart | Charts and Charting in Excel | |||
copy entire excel book | Excel Worksheet Functions | |||
copy chart from Excel to Powerpoint | Excel Discussion (Misc queries) | |||
Activating a Chart object | Charts and Charting in Excel | |||
Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel |