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

Chart Location Impact On Links When Copying To New Workbook 1
creating & linking multiple chart 1
hide original cells after creating chart 2
Excell Chart Background Wkst 3
Hiding source cell data after creating chart 1
Plot area distorted when I copy Excel chart into Powerpoint 1
Can we link Chart Labels to cells in the spreadsheet 1
copying chart to location within same workbook 2

Top