Thank you for the help. I will attempt one of these if it is a that option,
but i'm on a corporate network which presents me with two problems:

1) I may get in trouble for installing a third party app on this computer.
2) This worksheet will be worked on by many people after I'm gone (summer
internship) and whatever is done to it should probably be done with the stock
excel for compatibility reasons.

If anyone else has suggestions for anything I can do without a third party
app, I'd appreciate it. It doesn't have to say "no data". It could be as
simple as an "X", or a line, or just shading applied where the missing data
bar would go.

thanks

"Bernard Liengme" wrote:

I think you will need a column of data labels that could be placed on your
chart with one of these add-ins

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com

best wishes
--
Bernard Liengme
MVP Excel
http://people.stfx.ca/bliengme

"David NGC" <David wrote in message
...
Hello,
I am graphing a series of data in a bar format in excel. Some of the
entries have no data. Instead of interpolating, graphing zero, or just
leaving gaps, I'd like excel to put a "no data" or similar message in the
spot where a bar would otherwise be. (I can't have it shown as zero, as
there are legitimate zero entries as well.)

How do I do this? I am using excel 2003.