Forum Discussion

Copper Contributor

Mar 08, 2022

Solved

Correlation 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 least one dataPoint and I'm not sure what this means or how to put in a data point so I can move on.

excel

Grahmfs13
Mar 08, 2022
ZacPhil2, have you tried locking these cells within the correlation dialogue box? See example attached.

4 Replies

Grahmfs13
Former Employee
Mar 08, 2022
ZacPhil2, have you tried locking these cells within the correlation dialogue box? See example attached.
- ZacPhil2
  Copper Contributor
  Mar 08, 2022
  Just tried that and it worked thank you so much!
Grahmfs13
Former Employee
Mar 08, 2022
Hi 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.
- ZacPhil2
  Copper Contributor
  Mar 08, 2022
  My input range is A1:D6 and my output range is A8!