View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
David NGC David NGC is offline
external usenet poster
 
Posts: 1
Default excel "no data" labeling in bar graph

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.