Results 1 to 12 of 12

Need help with creating histogram. Error message: Input range contains non-numeric data.

Threaded View

cathy0922 Need help with creating... 10-03-2016, 01:09 AM
Glenn Kennedy Re: Need help with creating... 10-03-2016, 09:34 AM
cathy0922 Re: Need help with creating... 10-03-2016, 11:47 AM
MrShorty Re: Need help with creating... 10-03-2016, 12:05 PM
cathy0922 Re: Need help with creating... 10-03-2016, 12:21 PM
MrShorty Re: Need help with creating... 10-03-2016, 12:43 PM
cathy0922 Re: Need help with creating... 10-03-2016, 01:54 PM
MrShorty Re: Need help with creating... 10-03-2016, 02:22 PM
cathy0922 Re: Need help with creating... 10-03-2016, 02:34 PM
MrShorty Re: Need help with creating... 10-03-2016, 03:18 PM
cathy0922 Re: Need help with creating... 10-03-2016, 03:38 PM
BlindAlley Re: Need help with creating... 10-03-2016, 03:49 PM
  1. #5
    Registered User
    Join Date
    10-03-2016
    Location
    Los Angeles
    MS-Off Ver
    2013
    Posts
    6

    Re: Need help with creating histogram. Error message: Input range contains non-numeric dat

    @MrShorty Well, the picture has 243 values for both columns.

    I was given these instructions: Casey wants a chart representing the distribution of average hours per week that members utilized Inception Workspace in 2024. Switch to the Average Usage 2024 worksheet. Select the range A4:B243 and create a Histogram chart. (Hint: Use the Name box to select the range.) Modify the chart as described below:
    a. Resize and reposition the chart so that the upper-left corner is located within cell D4 and the lower-right corner is located within cell K18.
    b. Enter Average Weekly Usage (in Hours) in 2024 as the title of the chart.
    c. Modify the bins used in the chart by setting the Bin Width axis option to 10.


    The histogram should like look the picture I attached.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Numeric Range in Pivot Table can't be used to create a Histogram
    By Viral107 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-12-2015, 07:04 AM
  2. Replies: 0
    Last Post: 07-31-2013, 06:03 AM
  3. selecting resources via an input box, and then creating a simple histogram
    By armchairandy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-02-2012, 11:11 AM
  4. [SOLVED] How do you enter input range for a histogram
    By Irishrose28 in forum Excel General
    Replies: 0
    Last Post: 08-04-2006, 09:25 AM
  5. [SOLVED] I was creating a histogram; now i have data but no histogram.
    By ShannonMills3 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-13-2006, 07:10 PM
  6. [SOLVED] histogram, wrong input range
    By Camilla in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 03:25 AM
  7. Can I run a histogram with non-numeric data in Excel?
    By QATegan in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1