Share via

Non-Numeric data while graphing Histogram

Anonymous
2013-06-12T14:01:37+00:00

I am trying to graph a large data set in Microsoft Excel 2010 and I am receiving an Input Error- Non-Numeric data and the data set will not graph. What do I need to do with the data in order to make the histogram?

I am copying the data from a tab delimited file in excel into another workbook and I am having trouble graphing the entire data set.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-06-13T12:58:13+00:00

    I was able to find my problem in the data set. There were "NAN" comments in some of the cells which were causing the Histogram graphing software to return an input non-numeric data error.

    I used ctrl "f" to search the data set in the excel worksheet and was able to find the cells with non-numeric data and was able to resolve the problem.

    Is there our ways that I could eliminate or search the cells for Text data in the future?

    Thanks,

    A response would be much appreciated.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-06-13T09:57:34+00:00

    Hi Mathew,

    You may upload the sample file to the Sky drive using the thread link below to check and help you better:

    http://answers.microsoft.com/en-us/feedback/forum/suggest/how-to-insert-an-image-into-a-post-at-the/bdae0306-c3cb-4d31-ace9-7281ea1a8a73

    Note: Do not share the document which has confidential information.

    Thank you.

    Was this answer helpful?

    0 comments