Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Copy chart and paste it as a PICTURE back into Excel
Hi
Is there a way to copy a chart, and then paste (special) it as a picture back into Excel. It always pastes it back as a chart. Currently I can copy an excel chart and paste it into Word as a picture, then I copy it back out of Word and into Excel again. I want to do it as a single step. Perfectly acceptable alternate option would be knowing how to export a chart to file as a picture, and then my code could read that pic back in. Thanks in advance Andy C |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Copy chart and paste it as a PICTURE back into Excel
Try this
Tim '************** ActiveSheet.ChartObjects("Chart 1").Chart.CopyPicture _ Appearance:=xlPrinter, Size:=xlScreen, Format:=xlPicture ActiveSheet.Range("E27").Select ActiveSheet.Paste "AC" wrote in message ... Hi Is there a way to copy a chart, and then paste (special) it as a picture back into Excel. It always pastes it back as a chart. Currently I can copy an excel chart and paste it into Word as a picture, then I copy it back out of Word and into Excel again. I want to do it as a single step. Perfectly acceptable alternate option would be knowing how to export a chart to file as a picture, and then my code could read that pic back in. Thanks in advance Andy C |
#3
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Copy chart and paste it as a PICTURE back into Excel
Try this
Tim '************** ActiveSheet.ChartObjects("Chart 1").Chart.CopyPicture _ Appearance:=xlPrinter, Size:=xlScreen, Format:=xlPicture ActiveSheet.Range("E27").Select ActiveSheet.Paste "AC" wrote in message ... Hi Is there a way to copy a chart, and then paste (special) it as a picture back into Excel. It always pastes it back as a chart. Currently I can copy an excel chart and paste it into Word as a picture, then I copy it back out of Word and into Excel again. I want to do it as a single step. Perfectly acceptable alternate option would be knowing how to export a chart to file as a picture, and then my code could read that pic back in. Thanks in advance Andy C |
#4
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Copy chart and paste it as a PICTURE back into Excel
Hi,
Select the chart Hold down the Shift key and choose Edit, Copy Picture... A simple paste will do the trick at that point. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "AC" wrote: Hi Is there a way to copy a chart, and then paste (special) it as a picture back into Excel. It always pastes it back as a chart. Currently I can copy an excel chart and paste it into Word as a picture, then I copy it back out of Word and into Excel again. I want to do it as a single step. Perfectly acceptable alternate option would be knowing how to export a chart to file as a picture, and then my code could read that pic back in. Thanks in advance Andy C |
#5
Posted to microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Copy chart and paste it as a PICTURE back into Excel
You could try using the camera tool.
http://www.processtrends.com/pg_charts_camera_tool.htm "AC" wrote: Hi Is there a way to copy a chart, and then paste (special) it as a picture back into Excel. It always pastes it back as a chart. Currently I can copy an excel chart and paste it into Word as a picture, then I copy it back out of Word and into Excel again. I want to do it as a single step. Perfectly acceptable alternate option would be knowing how to export a chart to file as a picture, and then my code could read that pic back in. Thanks in advance Andy C |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy excel chart as picture to a particular ppt slides | Excel Programming | |||
Copy and Paste Chart as Picture into another workbook or worksheet | Charts and Charting in Excel | |||
Excel 2007 copy chart as picture | Charts and Charting in Excel | |||
copy then paste a chart as a picture | Excel Programming | |||
copy charts & paste as picture, hide chart, size & place same picture as chart | Excel Programming |