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?

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?

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

"Jon Peltier" wrote:

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?

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

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


"quattda" wrote in message
...
Yes there is a value in the cell. It is 1:15.

"Jon Peltier" wrote:

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?

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.

"Jon Peltier" wrote:

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

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


"quattda" wrote in message
...
Yes there is a value in the cell. It is 1:15.

"Jon Peltier" wrote:

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?

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?
--
David Biddulph

"quattda" wrote in message
...
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.

"Jon Peltier" wrote:

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

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


"quattda" wrote in message
...
Yes there is a value in the cell. It is 1:15.

"Jon Peltier" wrote:

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?