Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
na() and #na label displayed on graphs...
Hi all,
I have got a list of data and some are resulting from the NA() function. Objective is to avoid a 0 value plot on the graph..... and it is working great. BUT On the graph, I set the label of each ploy to "value". And unfortunately a #NA label is displayed on the graph on each plot where there is the NA()... How can I remove the #NA from my graph ? Thks, AL. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
na() and #na label displayed on graphs...
In a column or bar chart, you may as well use "". NA() is what works only
for marker series (line, XY, and some radar series) by completely hiding the point. In column and bars, the point is plotted, but has a value (and thus size) of zero; since the point is plotted, it can have a value in the data label. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... Hi all, I have got a list of data and some are resulting from the NA() function. Objective is to avoid a 0 value plot on the graph..... and it is working great. BUT On the graph, I set the label of each ploy to "value". And unfortunately a #NA label is displayed on the graph on each plot where there is the NA()... How can I remove the #NA from my graph ? Thks, AL. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text boxes that label axes in line/scatter graphs | Charts and Charting in Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
excel graphs line correctly, shows wrong value label? | Excel Discussion (Misc queries) | |||
Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Excel graphs with 1,000 or more points should not auto label | Charts and Charting in Excel |