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