| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Urgent - How to fix grayed out option under Tools|Options|Chart?
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 |
|
#2
|
|||
|
|||
|
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. S saturnin02 wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No Save As option | Excel Discussion (Misc queries) | |||
| XML Data menu option -- not listed / available. How do you fix thi | Excel Discussion (Misc queries) | |||
| Unable to unlock protection, Option Grayed out | Excel Worksheet Functions | |||
| How to protect Option button in worksheet | Excel Worksheet Functions | |||
| What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) | |||
Linear Mode
