ZacPhil2Copper ContributorMar 08, 2022SolvedCorrelation Analysis I am trying to use the Analysis ToolPak to create a correlational analysis graph but when I input my input range and output range and all that, then click OK, it says Input Range must contain at leas...Show MoreGrahmfs13Mar 08, 2022ZacPhil2, have you tried locking these cells within the correlation dialogue box? See example attached.Screen Shot 2022-03-08 at 11.04.30 AM.png375 KB
Grahmfs13Mar 08, 2022ZacPhil2, have you tried locking these cells within the correlation dialogue box? See example attached.Screen Shot 2022-03-08 at 11.04.30 AM.png375 KB
Grahmfs13Mar 08, 2022ZacPhil2, have you tried locking these cells within the correlation dialogue box? See example attached.Screen Shot 2022-03-08 at 11.04.30 AM.png375 KB
Grahmfs13Former EmployeeMar 08, 2022Hi ZacPhil2, can you please share the data ranges you are using? I've encountered this problem before, and my error was because my X and Y ranges did not exactly match up.
ZacPhil2Copper Contributor to Grahmfs13Mar 08, 2022My input range is A1:D6 and my output range is A8!
