| 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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
When I post to newsgroups my email address show with TRUENORTH in it. Can
you not see my address as you read this message? Alternative,Click the link in this message and you will find my real email address If I type my email address here I will get tooooo much spam! -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm not sure what remove TRUENORTH refers to? "Bernard Liengme" wrote: 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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
I can not see your address but did as you stated and will send the file in a
few minutes. Thanks so much! "Bernard Liengme" wrote: When I post to newsgroups my email address show with TRUENORTH in it. Can you not see my address as you read this message? Alternative,Click the link in this message and you will find my real email address If I type my email address here I will get tooooo much spam! -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm not sure what remove TRUENORTH refers to? "Bernard Liengme" wrote: 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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Histograms
Did you receive the Excel file I emailed to you? If so, any suggestions you
may have to offer would be greatly appreciated. Mike "Bernard Liengme" wrote: When I post to newsgroups my email address show with TRUENORTH in it. Can you not see my address as you read this message? Alternative,Click the link in this message and you will find my real email address If I type my email address here I will get tooooo much spam! -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "watermt" wrote in message ... I'm not sure what remove TRUENORTH refers to? "Bernard Liengme" wrote: 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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Did you receive my email?
Bernard, sorry to bother you but I've not had an email reply from you
regarding my Excel file I emailed to you? Did you receive it? Mike |
| 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) | |||
Linear Mode
