How can I copy a graph from one page to another

  • Thread starter Thread starter Stephane Pelletier
  • Start date Start date
S

Stephane Pelletier

Hi.

I have a graph on an excel worksheet that is base on data
from a second page. We have a third page that is
considered like the report template on which I would like
to paste a mirror image of the graph.

I'd like to copy a picture of the graph (and not the
graph itself) so that no one will be able to change the
data under the graph.

So is there a way to ... (using vba) ... copy a graph,
then transform it in any format(like.bmp), and then paste
it where I want?

Note: Platform is Windows XP Pro
Office XP pro.

Thanks for your help,

Stephane Pelletier
 
Stephane

Select the Chart.

Hold SHIFT key and Edit>Copy>Picture.

Paste Special>Picture to another worksheet.

Record a macro while doing this.

Gord Dibben Excel MVP
 
Back
Top