software

background:

I import data into my excel worksheet from a call logging database and use
excel to create graphs for statistics etc, this works fine, however I want to
generate a graph that shows the call resolution times i.e the amount of
hours/min between a call being logged and closed. I have generated the
resolution times using formula to calculate the difference between two
dates/times.

Problem:

I select the data range and click on the create chart button, but no matter
what chart type I select, the graph is pretty much blank with just a single
figure/value showing quot;1quot;. The data I have selected is as follows....

1:09
1:08
0:20
0:06
0:29
2:58
2:52
2:49

As you can see the amount of data is not huge and is simple enough, any
ideas as to why the graph wont show the values?

Problem 2:

Also as a seperate issue I am unable to calculate an average on the above
values, whichever average formulae I use it generates an error e.g
=AVERAGE(R4:R11) or =AVERAGEA(R4:R11)

Any helps appreciated.

What do you get for
=COUNT(R4:R11)
If zero, then your data is not recognized as numeric (Excel time values are
numeric), which would cause both problems.

Jerry

quot;S Sainsburyquot; wrote:

gt; background:
gt;
gt; I import data into my excel worksheet from a call logging database and use
gt; excel to create graphs for statistics etc, this works fine, however I want to
gt; generate a graph that shows the call resolution times i.e the amount of
gt; hours/min between a call being logged and closed. I have generated the
gt; resolution times using formula to calculate the difference between two
gt; dates/times.
gt;
gt; Problem:
gt;
gt; I select the data range and click on the create chart button, but no matter
gt; what chart type I select, the graph is pretty much blank with just a single
gt; figure/value showing quot;1quot;. The data I have selected is as follows....
gt;
gt; 1:09
gt; 1:08
gt; 0:20
gt; 0:06
gt; 0:29
gt; 2:58
gt; 2:52
gt; 2:49
gt;
gt; As you can see the amount of data is not huge and is simple enough, any
gt; ideas as to why the graph wont show the values?
gt;
gt; Problem 2:
gt;
gt; Also as a seperate issue I am unable to calculate an average on the above
gt; values, whichever average formulae I use it generates an error e.g
gt; =AVERAGE(R4:R11) or =AVERAGEA(R4:R11)
gt;
gt; Any helps appreciated.