I right click the sheet tab with the charts on them, select move or copy,
place check mark in copy and enter. I am using 2007

"MacPadana" wrote in message
...
Thanks for the reply. I wasn't aware of that way of copying.
Unfortunately, I
get the same results.

Anyone else?


"Pete_UK" wrote:

Normally, I just do a CTRL-drag on the sheet tab to copy a sheet in
its entirety (including graphs, which then refer to the cells on the
copied sheet). Mind you, I don't have XL2007, so I can't test this out
for you.

Hope this helps.

Pete

On Feb 5, 4:12 pm, MacPadana
wrote:
I've just started working with Excel 2007 and I'm having a little
trouble.. I
have a sheet with charts showing data for January. I wanted to create
11 more
sheets just like it for the rest of the year. I right click the tab,
choose
'Create Copy" and hit OK. A new tab appears just like always but there
are no
charts! I can copy and paste the charts seperately into the new sheet,
but
they reference the data in the January tab. Any help would be
appreciated..

Thanks,

Mac