copying two charts

[Oli]

I am trying to copy two charts along with its name and legend. When I past it
in another worksheet I only get the legend and the chart name and NOT the
chart. How can I copy both charts, name and legend at the same time? I have a
list of charts that I need to combine in one page for printing options.

Thank you!
Oli

 

[Peo Sjoblom]

Try this

press F5, click special, select objects, click OK or press enter, do Ctrl +
C and paste into another sheet

Regards,

Peo Sjoblom

 

[Oli]

I followed your proceduresand I was able to get the chart, but not the title
because the title is on top with a drop down arrow. The title are names of
countries and when I click the drop down arrow I can view a different
country's chart each time. it si a pivot table chart I think. I am not too
familiar with excel and I really appreciate your help!

Thank you,
Oli