Dont want to display a point in chart

  • Thread starter Thread starter Ashu
  • Start date Start date
A

Ashu

I have a chart which shows values by month (X-axis =month;
y-axis = %).
I have a formula which calculates data for each month. For
the months where there's no data, I do not want the chart
to display any values. Right now, even if there are no
values (or text, or error msg, etc.), the chart assumes it
is a zero and displays the same.
Please help.
Thanks.
 
Your formula probably contains a "" for the cases that lack data.
Replace that with NA()

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2004
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top