how do i remove the cells from a sheet when working with a chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a chart but I want to remove the cells, so the background is gray
and nothing can be selected except the chart. Thank you.
 
instead of greying out you can hide the cells or column but chart also may
disappear but see this message from Andy Pope to one of the queries in the
newsgroup

quote
Hi Rick,
Yes there is, Select the chart and then use the menu Tools > Options.
On the chart tab is a checkbox 'Plot Visible Cells Only', uncheck this
to get your chart working.
Cheers
Andy
unquote
 
On the chart menu, select Location, and choose the As New Sheet option, and if
desired, type a better name in the box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
You must log in or register to reply here.

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

How to create a bubble chart with more than 2 variables 0
One Chart, Same Data ranges, different source sheets 4
How do I disable "Plot visible cells only" when it is greyed out? 1
One extra x axis item that wont go away - can anyone help? 3
Error with Chart as new sheet 4
Can we link Chart Labels to cells in the spreadsheet 1
How to chart months by financial year 0
Inside Base Series Label Showing #N/A 0

Back
Top