Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Omitting zeroes when looking for minimum values | Excel Worksheet Functions | |||
how do i remove zeroes values from exel sheet | New Users to Excel | |||
Want chart to display total of values | Charts and Charting in Excel | |||
Display Error Bar values on chart? | Charts and Charting in Excel | |||
Don't won't charts to display Zeroes | Charts and Charting in Excel |