hide workbook behind chart

W

Whiley E Coyote

Hi,

I am dealing with a pre-owned spread-sheet. It has nice charts in each
worksheet; when looking at these charts the background of the worksheet is
not visible - the chart appears to be "floating" in the workshhet . Whenever
I add a new chart to the book (on a new worksheet) I get a chart sitting atop
a grid of cells. How can I make my new charts pretty like the other ones?

Bill...
 
J

Jon Peltier

The "nice" chart you describe is not embedded in a worksheet, instead it is
its own chart sheet. In step 4 of the chart wizard you have a choice whether
to create the chart as an object in a sheet or as a new sheet: choose the
new sheet option. For an existing chart, right click and choose Location to
get the same dialog as in the wizard, and change to the new sheet option.

- Jon
 

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

Charts not visible 0
Chart Location Impact On Links When Copying To New Workbook 1
Change Chart Name Event 0
Charts in Multiple Sheet in Excel 1
Why do charts disappear? 3
copy chart between multiple sheets in workbook 4
creating & linking multiple chart 2
Pasting chart worksheet as link 2007 2

Top