View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default excel "no data" labeling in bar graph

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.