A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Bar data not displaying



 
 
Thread Tools Display Modes
  #1  
Old July 21st, 2007, 11:44 PM posted to microsoft.public.excel.charting
quattda
external usenet poster
 
Posts: 14
Default Bar data not displaying

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(D8L 8)),$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?
  #2  
Old July 25th, 2007, 03:13 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Bar data not displaying

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(D9L9)0,COUNT(D9L9)=COUNT(D8L 8)),$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?



  #3  
Old July 26th, 2007, 01:30 AM posted to microsoft.public.excel.charting
quattda
external usenet poster
 
Posts: 14
Default Bar data not displaying

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(D9L9)0,COUNT(D9L9)=COUNT(D8L 8)),$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?




  #4  
Old July 26th, 2007, 04:10 AM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default Bar data not displaying

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(D9L9)0,COUNT(D9L9)=COUNT(D8L 8)),$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?






  #5  
Old July 27th, 2007, 03:28 AM posted to microsoft.public.excel.charting
quattda
external usenet poster
 
Posts: 14
Default Bar data not displaying

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(D9L9)0,COUNT(D9L9)=COUNT(D8L 8)),$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?






  #6  
Old July 27th, 2007, 07:30 AM posted to microsoft.public.excel.charting
David Biddulph
external usenet poster
 
Posts: 8,714
Default Bar data not displaying

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(D9L9)0,COUNT(D9L9)=COUNT(D8L 8)),$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?








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.