Unable To Create Simple Chart
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. |
Unable To Create Simple Chart
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. |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com