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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|