Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007- unwanted column chart n/a labels displaying
I am using Excel 2007 and have found that I cannot get the NA() labels to NOT
display. As desired, there is no column where the cell values are na() but the labels for those cells are displaying as "N/A". How do I keep these labels from appearing? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007- unwanted column chart n/a labels displaying
Interesting. I made a Line chart with =NA() and the points were joined (as
expected) When I added labels, the #N/A did NOT appear A copy of the same charge was changed to a Column chart and the #N/A does appears But then, with a column chart you could just leave the cell blank. What type of chart are you using? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Arnett" wrote in message ... I am using Excel 2007 and have found that I cannot get the NA() labels to NOT display. As desired, there is no column where the cell values are na() but the labels for those cells are displaying as "N/A". How do I keep these labels from appearing? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007- unwanted column chart n/a labels displaying
The advice about using NA() in a formula to hide a data point works fine for
line or XY charts. The best advice for a column or bar chart is to use "" instead. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bernard Liengme" wrote in message ... Interesting. I made a Line chart with =NA() and the points were joined (as expected) When I added labels, the #N/A did NOT appear A copy of the same charge was changed to a Column chart and the #N/A does appears But then, with a column chart you could just leave the cell blank. What type of chart are you using? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Arnett" wrote in message ... I am using Excel 2007 and have found that I cannot get the NA() labels to NOT display. As desired, there is no column where the cell values are na() but the labels for those cells are displaying as "N/A". How do I keep these labels from appearing? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007- unwanted column chart n/a labels displaying
I'm actually using a combination column and line chart and when I ran into
the problem for the line chart series, I used the =NA() solution I had found from a previously posted question here. What I also did was change all my formulas in the data ranges to use the =NA() instead of the "". That's probably what caused the problem with the column series. I don't have the Workbook here but I'll try it tonight when I go home and let you know. "Bernard Liengme" wrote: Interesting. I made a Line chart with =NA() and the points were joined (as expected) When I added labels, the #N/A did NOT appear A copy of the same charge was changed to a Column chart and the #N/A does appears But then, with a column chart you could just leave the cell blank. What type of chart are you using? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Arnett" wrote in message ... I am using Excel 2007 and have found that I cannot get the NA() labels to NOT display. As desired, there is no column where the cell values are na() but the labels for those cells are displaying as "N/A". How do I keep these labels from appearing? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Chart labels | Excel Discussion (Misc queries) | |||
Column Chart, Displaying two values on one column. | Charts and Charting in Excel | |||
not displaying pie chart in excel 2007 | Charts and Charting in Excel | |||
how to keep data labels in chart in 2007 from changing? | Charts and Charting in Excel | |||
Excel 2003 Unwanted Data Labels | Excel Discussion (Misc queries) |