I keep getting a "no" symbol when trying to edit certain graphs.

S

Shane Devenshire

Hi,

A lot more detail would help. What type of chart? What do you mean by "no"
symbol? #? Where are you seeing the "no" - in the chart title, on an axis,
in the plot area, for all data points, for only some data points, in the
spreadsheet. What does your data, in the spreadsheet, look like?
What version of Excel are you using?
 
J

Jon Peltier

In addition to Shane's questions: What is it you're trying to do? Are you
completely unable to edit these charts, or just unable to do certain things?
Are they pivot charts? Are they on protected worksheets or in shared
workbooks?

- Jon
 
D

D

After a Google search, I came across this thread. I am experiencing the exact
same problem with a "no" symbol--the symbol is a black circle with a single
line crossed through it at an angle. It occurs whenever the cursor is above a
graph in Excel 2007--I am unable to left or right click on the graph, or
highlight it in any way. I know this is not a problem with my computer, as I
tried opening it again on a different computer and have the same problem. Is
there any way to fix this so that I don't have to trash the project and start
over again, or at least to prevent this from happening in the future?

Thanks.
 
J

Jon Peltier

Is this occurring in only one workbook? Is that workbook shared? Are the
worksheets grouped?

- Jon
 
D

D

I think I may heave fixed the problem--they may have been accidentally shared
or protected in some way. Is it possible to protect a group of workbooks
without a password? In any case, I can now edit the graphs. Thanks!
 
J

Jon Peltier

If you group worksheets, that is, select more than one at a time, you can't
do anything with charts on those sheets.

- Jon
 

JDE

Joined
Dec 4, 2015
Messages
1
Reaction score
0
I had the same problem. All I needed to do was open the source data feeding the charts - in my case, another workbook. Hope this helps.
 

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

Top