Thread
:
Can't save chart as object in current sheet
View Single Post
#
2
Barb Reinhardt
Posts: n/a
I have Excel 2003 and was able to toggle this on and off. I went to
Options, View and for the Objects selection, I chose HIDE ALL for Objects.
With that setting, I could not save the graph as an Object within the
Worksheet. I started out with the setting at Show All. Try that and see
what happens.
"Ann Scharpf" <Ann
wrote in message
...
I am using Excel 2000. I have copied an existing file to use as a
template.
One sheet contains a table of data that I want to chart. When I get to
the
last step of the chart wizard, the option is grayed out for saving the
chart
as an object on one of the sheets.
I was able to work around the problem by using the copy sheet command to
copy all the sheets to a new workbook. I cannot figure out what the
original
user could have done to this file to make the "create as object" option
unavailable. I'd appreciate any insight you can give me.
Thanks.
Reply With Quote