Multiple Histogram Errors; Multiple Sheets

sjjna

New Member
Joined
Aug 13, 2014
Messages
3
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

New Member
Joined
Aug 13, 2014
Messages
3
I don't know if there is a way to attach my file or not, or if that would help?
 

sjjna

New Member
Joined
Aug 13, 2014
Messages
3
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.
 

Forum statistics

Threads
1,085,303
Messages
5,382,825
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top