Urgent - How to fix grayed out option under Tools|Options|Chart?

  • Thread starter Thread starter saturnin02
  • Start date Start date
S

saturnin02

Win XP HE, XL 2002 SP3
Hi,
I am doing a rush presentation and am stuck...!
Under Tools|Options| Chart tab, the otion to "Plot empty cells as: Not
plotted" is grayed out.
Yet, that is precisely what I need to do.
How can I fix that?
I have other charts where the optin is available.
What am I doing wrong?
S
 
I found out the following: I had an "area chart" which (by definition I
guess) will build the area from "0". Changing it to a line chart, did the
trick.
 

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

Excel 2007 Chart Options 4
chart is grayed out 3
shared workbook - shared workbook options grayed out 0
Options menu grayed out in Excel 2002 1
Keep macros from being ran under the tools option in the menu bar 3
The password option is grayed out under the Security tab 3
How do I disable "Plot visible cells only" when it is greyed out? 1
Centering Axis and Chart Titles on chart 1

Back
Top