Spreadsheet: 707118d1607042817-need-to-do-a-multiple-chart-reference-formula-multi-chart-fx
Sheet: Sheet1

 |  |  |  |  |  |  | Chart 1 |  |  |  |  |  | Reps
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  | 7 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753 | 0.745 | 0.738
 |  |  |  |  |  |  |  | 7.5 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756 | 0.749 | 0.741
 |  |  |  |  |  |  | R | 8 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753 | 0.745
 | Chart 1 | Chart 2 | Chart 3 |  |  |  | P | 8.5 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756 | 0.749
 | Exercise 1 | Exercise 9 | Exercise 17 |  |  |  | E | 9 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753
 | Exercise 2 | Exercise 10 | Exercise 18 |  |  |  |  | 9.5 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756
 | Exercise 3 | Exercise 11 | Exercise 19 |  |  |  |  | 10 | 1 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76
 | Exercise 4 | Exercise 12 | Exercise 20 |  |  |  |  | 11 | 1.025 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764
 | Exercise 5 | Exercise 13 | Exercise 21 | Exercise 1 |  |  | Chart 2 |  |  |  |  |  | Reps
 | Exercise 6 | Exercise 14 | Exercise 22 | 500 | weight |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Exercise 7 | Exercise 15 | Exercise 23 | 3 | reps |  |  | 7 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753 | 0.745 | 0.738
 | Exercise 8 | Exercise 16 | Exercise 24 | 9 | RPE |  |  | 7.5 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756 | 0.749 | 0.741
 |  |  |  |  |  |  | R | 8 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753 | 0.745
 |  |  |  |  |  |  | P | 8.5 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756 | 0.749
 |  |  |  |  |  |  | E | 9 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76 | 0.753
 |  |  |  |  |  |  |  | 9.5 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764 | 0.756
 |  |  |  |  |  |  |  | 10 | 1 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.783 | 0.775 | 0.768 | 0.76
 |  |  |  |  |  |  |  | 11 | 1.025 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.786 | 0.779 | 0.771 | 0.764
 |  |  |  |  |  |  | Chart 3 |  |  |  |  |  | Reps
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  |  |  |  | 7 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.784 | 0.779 | 0.773 | 0.768 | 0.762 | 0.756 | 0.751
 |  |  |  |  |  |  |  | 7.5 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.787 | 0.782 | 0.776 | 0.77 | 0.765 | 0.759 | 0.753
 |  |  |  |  |  |  | R | 8 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.784 | 0.779 | 0.773 | 0.768 | 0.762 | 0.756
 |  |  |  |  |  |  | P | 8.5 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.787 | 0.782 | 0.776 | 0.77 | 0.765 | 0.759
 |  |  |  |  |  |  | E | 9 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.784 | 0.779 | 0.773 | 0.768 | 0.762
 |  |  |  |  |  |  |  | 9.5 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.787 | 0.782 | 0.776 | 0.77 | 0.765
 |  |  |  |  |  |  |  | 10 | 1 | 0.95 | 0.9 | 0.85 | 0.835 | 0.82 | 0.805 | 0.79 | 0.784 | 0.779 | 0.773 | 0.768
 |  |  |  |  |  |  |  | 11 | 1.025 | 0.975 | 0.925 | 0.875 | 0.843 | 0.828 | 0.813 | 0.798 | 0.787 | 0.782 | 0.776 | 0.77