Dont want to display a point in chart

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.
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Gantt chart duration not showing 0
Creating a Chart on form from selected data in query. 0
column charts with set set of data 0
simple chart 0
Dynamic series in rows 1
Adding a line to a population bar chart 0
Labeling on independently stacked line chart 0

Top