Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Chart Plot #N/A Data labels
OK - I'm using the =na() trick to keep missing values from plotting a
zero value. Now, the only issue I can’t resolve is the data labels. Excel is labeling the missing (empty) points with "#N/A" This is not the behavior I desire. I'd like Excel to "not label" those (missing) points associated with =na() Any ideas?? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 Chart Plot #N/A Data labels
What chart type? The NA() trick is for line and XY charts. Bar and Column
charts require "" instead. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dave" wrote in message ... OK - I'm using the =na() trick to keep missing values from plotting a zero value. Now, the only issue I can’t resolve is the data labels. Excel is labeling the missing (empty) points with "#N/A" This is not the behavior I desire. I'd like Excel to "not label" those (missing) points associated with =na() Any ideas?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change All Data Labels in Excel 2007 Stacked Bar Chart | Charts and Charting in Excel | |||
Excel 2007: Stacked column chart with white data labels | Charts and Charting in Excel | |||
Filtering data for scatter plot with chart labels | Charts and Charting in Excel | |||
getting data labels on xy chart from additional plot area | Charts and Charting in Excel | |||
how to keep data labels in chart in 2007 from changing? | Charts and Charting in Excel |