| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Histograms
I'm working on a spreadsheet that is used to collect data (in the [hh]:mm
format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
If the items are 'real times' then they are already numeric.
If one of the time values is in B2 what does the formula =ISNUMBER(B2) return? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm working on a spreadsheet that is used to collect data (in the [hh]:mm format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
False
"Bernard Liengme" wrote: If the items are 'real times' then they are already numeric. If one of the time values is in B2 what does the formula =ISNUMBER(B2) return? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm working on a spreadsheet that is used to collect data (in the [hh]:mm format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
Then you must replace all these values by real time values by retyping them.
If there are more than 20, send me a file and I will see if a formula is possible best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... False "Bernard Liengme" wrote: If the items are 'real times' then they are already numeric. If one of the time values is in B2 what does the formula =ISNUMBER(B2) return? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm working on a spreadsheet that is used to collect data (in the [hh]:mm format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
Yes, there are 137 values in two worksheets in the workbook. What is your
email address to send the file? "Bernard Liengme" wrote: Then you must replace all these values by real time values by retyping them. If there are more than 20, send me a file and I will see if a formula is possible best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... False "Bernard Liengme" wrote: If the items are 'real times' then they are already numeric. If one of the time values is in B2 what does the formula =ISNUMBER(B2) return? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm working on a spreadsheet that is used to collect data (in the [hh]:mm format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
remove TRUENORTH.
-- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... Yes, there are 137 values in two worksheets in the workbook. What is your email address to send the file? "Bernard Liengme" wrote: Then you must replace all these values by real time values by retyping them. If there are more than 20, send me a file and I will see if a formula is possible best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... False "Bernard Liengme" wrote: If the items are 'real times' then they are already numeric. If one of the time values is in B2 what does the formula =ISNUMBER(B2) return? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm working on a spreadsheet that is used to collect data (in the [hh]:mm format) and when I go to put the data rnage into a Histogram I get a message stating the following: Histogram - Input range contains non-numeric data. Can someone help me with this? Do I need to conver the times to a decimal format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Histograms | Excel Discussion (Misc queries) | |||
| Histograms | Excel Discussion (Misc queries) | |||
| histograms | Excel Worksheet Functions | |||
| Histograms | Excel Discussion (Misc queries) | |||
| histograms | Excel Discussion (Misc queries) | |||
Hybrid Mode
