Problem trying to create a "values only" sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elliott Alterman - 24 Sep 2006 23:39 GMT

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

Reply to this Message

Pete_UK - 25 Sep 2006 09:51 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Elliott Alterman - 25 Sep 2006 14:12 GMT

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

> 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
[quoted text clipped - 14 lines]
>>
>> Thanks

Reply to this Message