| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't plot non-values on a chart
Lenin
I tried this but somethings not right. If I enter =na() directly into the cell it does not plot zero (which is what I want However I want to do this from code as tried the following and test1 returns #VALUE! and test2 return #N/A as a string but excel treats this as 0 (not what I want Want have I missed Bria Function test1( test1 = Application.WorksheetFunction.na( End Functio Function test2( test2 = "#N/A End Functio |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Plot Data with X, Y values on Chart | Excel Discussion (Misc queries) | |||
| How to plot chart where X axis values START 1 | Charts and Charting in Excel | |||
| how do I setup a pie chart that does not plot zero values ? | Charts and Charting in Excel | |||
| Unable to Plot Values on Chart | Charts and Charting in Excel | |||
| BUG?: Excel scatter chart: will not plot x-values | Excel Discussion (Misc queries) | |||
Threaded Mode
