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 "1". 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

"S Sainsbury" wrote:

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 "1". 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.