Bar data not displaying

[quattda]

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(D9L9)<>0,COUNT(D9L9)=COUNT(D8L8)),$B$2-(SUM(D9L9)-SUM(D8L8)),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?

 

[Jon Peltier]

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

- Jon

 

[quattda]

Yes there is a value in the cell. It is 1:15.

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
_______

 

[Jon Peltier]

What kind of values might you see when the bar is charted?

- Jon

 

[quattda]

If there is even one minute of time used in the calculation (e.g., Begin time
11:35am, End time 11:36am), the correct time remaining after substracting it
from 1:15minutes is displayed correctly on the graph as a bar. The problem is
when there is no beginning and end time entries. According to the IF-Then
construct, I would think that 1:15 should be displayed on the graph. It does
not even though it is displayed in the cell.

 

[David Biddulph]

Are you sure that you are pointing at the right cell? I notice that you
have $B$2 in your subtraction formula, and B2 in the exception case. When
you are looking at a value not plotted, is this in the original cell from
which the formula is quoted, or in another row to which the formula has been
copied with relative addressing?

For the cell that isn't plotted in the graph, what value do you see if you
format the cell as a number?