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 |
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 |
All times are GMT +1. The time now is 12:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com