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

"Peo Sjoblom" wrote:

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" wrote in message
...
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