Problem trying to create a "values only" sheet

[Elliott Alterman]

I have a rather large spreadsheet full of basic data and a lot of derived
statistics - the stats are in 1 of the worksheets. I want to be able to send to
a number of folks ONLY the statistics sheet and in a values-only form. I did a
"COPY" and "PASTE SPECIAL - VALUES" for the stats sheet and then deleted the
other sheets. It all works fine except for the charts that are in the stats
sheet - they end up blank in terms of data plotted. How can I correct that problem?

Thanks

 

[Pete_UK]

Perhaps you should have taken a copy of the Stats sheet (using
CTRL-drag) so that the charts go with it, and then fixed the values in
the copy of the sheet. It might be that the charts refer to ranges
which are in the sheets you deleted, so check for these and if
necessary cut/paste to the copy of the Stats sheet.

Hope this helps.

Pete

 

[Elliott Alterman]

Thanks for your thoughts. That's what I had tried to do. I think I will redo the
charts to avoid the problem.