Multiple Histogram Errors; Multiple Sheets

[sjjna]

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?

 

[sjjna]

I don't know if there is a way to attach my file or not, or if that would help?

 

[sjjna]

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.