Thread: How to move the chartsheet(leaving the raw data sheet in the orig file) to a new file

I have a file with 20ish sheets, roughly ~10 graph sheets and ~10 corresponding raw data sheets.
Every week I need to make a distribution file (only the graph sheets) and email them to a bunch of guys.

In order to do this, I open the file, select all the graph sheets, move them to a new file, save, close, and close the original file without saving.
Which should, do the trick, according to a lot of the web posts I've seen.

But I'm having problems.

1) Some of the graphs have defined names as data ranges. (Someone else drew them, and defined 40+ names for each data series)
When separated from their data sheet, these graphs don't seem to show up at all.

2) Some of the graphs do show up, but their formatting is all wrong. (axis gets all messed up)

3) Some of the graphs simply don't show up.

4) Some do show up.


My question is.

Do I have to "un-name" all the data ranges so they direct to specific cells rather than names for graphs that fall in to category #1 in order for those graphs to show up without the raw data sheet?

Why am I having problems #2,3,4 when they are all drawn the same(seemingly) way by me?

How would I fix this?

Thanks a lot in advance.

If you are only sending charts for view why not create pdf output or images of charts rather than breaking the charts from the data.