Do you get a value in the cell even if the chart doesn't plot a bar? What is
the value?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"quattda" wrote in message
...
I am trying to create a bar chart that refers to a set of cells which are
calculating the remaining time after subtracting the differences between
beginning and end times from a static time value (1:15) using the
following
formula:
=IF(AND(COUNT(D9:DL9)<0,COUNT(D9:DL9)=COUNT(D8:DL 8)),$B$2-(SUM(D9:DL9)-SUM(D8:DL8)),B2)
The B2 cell refers to the static time of 1:15 that is formated as h:mm. If
there is no start and end time values in the range and therefore the cell
is
assigned a IF-FALSE value of 1:15, when the bar chart is created there is
no
bar value displayed in the chart. If there are start and end time values
in
the range, a correct time value is represented as a bar.

Any suggestions about what might happening?