Can't save chart as object in current sheet

A

Ann Scharpf

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.
 
B

Barb Reinhardt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
Save a custom chart as a template 0
Chart Location Impact On Links When Copying To New Workbook 1
Odd Chart Format Results 1
Change background / color of chart worksheet? 3
how to display multiple charts on a single chart sheet 1
Can't close old pst file 2
copy chart between multiple sheets in workbook 4

Top