Hi,
You can use a dummy series to provide the No Data text.
Assume data layout as follow, <empty is just a place holder for email post.
A1:<empty B1: =Data C1: =NoData
A2: =a B2: = 1 C2: =<empty
A3: =b B3: = <empty C3: =0
A4: =c B4: = 0 C4: =<empty
A5: =d B5: = 3 C5: =<empty
Plot both series as clustered bar. Set Overlap value to 100.
Series 1 displays data labels of Value
Series 2 displays data labels of Series Name
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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.