| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cannot find "Plot empty cells as" option in 2007
Excel has the option under
Tools - Options - Chart tab Plot empty cells has - Not plotted (leave gaps) - Zero - Interpoloated i cannot find the option in Excel 2007, after hunting off and on for 3 hours. Where is it? i've already dismissed the hack of filling values with the formula =NA() References http://support.microsoft.com/kb/302672 http://j-walk.com/ss/excel/usertips/tip024.htm http://www.excelforum.com/excel-char...ng-values.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Option "Sized with Window" in XL 2007 ?? | Charts and Charting in Excel | |||
| i do not see the "plot series on" option in Excel 2007 | Charts and Charting in Excel | |||
| Using the "Find" option across multiple tabs in one worksheet | Excel Discussion (Misc queries) | |||
| Excel 2007 "Find" option won't work. | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Threaded Mode
