Hide Data label in Excel Chart

[schultpa]

I am trying to create a chart in excel for one of my managers and I want to have the formulas pre-populated for the chart.

I am having trouble displaying the data labels on the chart. Future quarters (because there are formulas in the corresponding cells, not blanks), show a data label on the chart (either (-) or (#N/A) depending on my formula)

Is there a way to hide this without adding the data labels one at a time (which I don't want my manager to have to do)?

 

[tusharm]

Replace the - or #N/A with ""?

Also, depending on what exactly you are doing and how you are going about it, check
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html