+ Reply to Thread
Results 1 to 4 of 4

Multiple Histogram Errors; Multiple Sheets

  1. #1
    Registered User
    Join Date
    08-13-2014
    Location
    Longview, WA
    MS-Off Ver
    2010
    Posts
    12

    Question Multiple Histogram Errors; Multiple Sheets

    My goal: I will have 5 sheets with 5 different sets of data and bins on each sheet. I will also be including a lined scatter plot and a histogram graph of each set of data on each sheet (25 total). I want to only have the histogram chart visible on each sheet (i.e, I don't want my sheet to have the bins/frequency table).

    Where I am at: I have built the first sheet with 5 sets of data and 5 scatter plots. I have build the 1st histogram in a sixth sheet and copied, pasted special(with formatting) the first histogram graph from sheet 6 to sheet1.

    My problem: I cannot create another histogram in sheet6. If I try to create it from sheet 1 and choose the output to be sheet6! A8 or something like that, it changes it to [filename.xls]Sheet6!A8, even though I am not referencing an outside spreadsheet. When it does this I get the error output range must be a valid reference.

    If instead I try to start making the histogram from sheet6, still using the data from sheet1, I will get the error message Input range must be a contiguous reference. I am not doing anything different from making the first histogram to the second, except for setting an output, so i don't understand what is wrong. Can anyone answer this?

  2. #2
    Registered User
    Join Date
    08-13-2014
    Location
    Longview, WA
    MS-Off Ver
    2010
    Posts
    12

    Re: Multiple Histogram Errors; Multiple Sheets

    The file is attached now.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-13-2014
    Location
    Longview, WA
    MS-Off Ver
    2010
    Posts
    12

    Re: Multiple Histogram Errors; Multiple Sheets

    Also, It works fine if I don't try to specify an output. But then I will end up with 25 sheets, each with on histogram. I'm trying to make this a little more manageable and condensed.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,997

    Re: Multiple Histogram Errors; Multiple Sheets

    Can I assume you are doing this from the Histogram tool? Considering some of these difficulties, have you considered structuring the spreadsheet so you don't need to invoke the histogram tool?

    For assembling the data, I would consider using the FREQUENCY() function (this is essentially what the histogram tool uses, anyway) to "count" the data: http://office.microsoft.com/en-us/ex...in=HP010342656

    The histogram chart is then a simple column chart based on the bins + counts data: http://office.microsoft.com/en-us/ex...663.aspx?CTT=1

    You can use an INDIRECT() function for the function references so you can simply enter a sheet name to count data in that sheet. http://office.microsoft.com/en-us/ex...in=HP010342656

    Does that help?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Counting multiple items with multiple criteria from multiple sheets?
    By essee in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2013, 01:56 AM
  2. Replies: 1
    Last Post: 03-19-2013, 07:03 PM
  3. Histogram using data from multiple sheets
    By Muscles, ymailk in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-04-2012, 03:53 PM
  4. Merge multiple excels with multiple sheets in a master excel with multiple sheets
    By marchi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2012, 10:37 AM
  5. [SOLVED] Histogram made from multiple exel work books.
    By frank in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2005, 04:05 PM

Tags for this Thread

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