Thank You Andy for your response---How Do I change the data labels to show NA when there is no data?
I have the formula set up to show NA when there is no data however it still comes out as 0 in the chart.
Can someone please help me ove this hurdle?
I am charting datain a bar graph where some data is 0% and other places it is No data. I need to distinguish betweenthe two of these in my chart.
The chart does not plot anything if there is 0% or if there is no data to chart.