Hidden and empty cells
claudine
-
redaiwa Posted messages 370 Status Member -
redaiwa Posted messages 370 Status Member -
Hello,
After browsing your forum (and many others!), I couldn't find the answer to my question. I thus allow myself to submit it to you:
In Excel 2007, I want to display empty cells as gaps on my chart. However, in the "hidden and empty cell settings" option, I do not have access to the "gaps" choice (nor the "connect data points with line" option), which is grayed out. Only the "zero value" option is active.
Do you know how to access the "gaps" option, please?
Thank you in advance for your response,
Claudine
Configuration: Windows 7 / Mozilla 11.0
After browsing your forum (and many others!), I couldn't find the answer to my question. I thus allow myself to submit it to you:
In Excel 2007, I want to display empty cells as gaps on my chart. However, in the "hidden and empty cell settings" option, I do not have access to the "gaps" choice (nor the "connect data points with line" option), which is grayed out. Only the "zero value" option is active.
Do you know how to access the "gaps" option, please?
Thank you in advance for your response,
Claudine
Configuration: Windows 7 / Mozilla 11.0
1 answer
Salam Claudine.
The options "intervals," "zero value," and "connect data points with a curve" are available or not depending on the type of chart used. If you use the "areas" type, for example, only the "zero value" option will be available.
I hope I was helpful… even if it's late :)
--
"Repel evil with good; then the one with whom you had animosity will become like a warm friend." (Quran)
"He who does not know how to share is emotionally disabled." (Marc Levy)
The options "intervals," "zero value," and "connect data points with a curve" are available or not depending on the type of chart used. If you use the "areas" type, for example, only the "zero value" option will be available.
I hope I was helpful… even if it's late :)
--
"Repel evil with good; then the one with whom you had animosity will become like a warm friend." (Quran)
"He who does not know how to share is emotionally disabled." (Marc Levy)