View Single Post
  #1   Report Post  
Old May 19th 09, 04:16 AM posted to microsoft.public.excel.charting
Bagia Bagia is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 46
Default Chart to display zeroes values

Hello,

I have a strange question. I have a clustered column chart where some values
are zero. In such cases, no column appears for these observations (i.e. a
column of zero height). Anyway to make the column appears for these zero
values? There are 8 categories (a thru h) and I want to display 8 bars
representing each category even if the value is zero. Then, I would like to
have the data label displays inside each of the bar representing the value.
Can this be done?

with the following group of data
F08 F09 F10 F11 F12
a 2 0 0 0 0
b 0 0 0 3 1
c 1 1 0 0 0
d 1 2 0 1 1
e 2 0 0 1 0
f 0 0 0 0 3
g 1 0 1 0 0
h 1 0 0 1 0