Unfortunately I cannot upload the work book, but
If I wanted to take this data from sheet 1 (manually input) and transfer it to populate the data for this chart on sheet 2
@MikeP1978 , it's not necessary to upload your actual workbook, you may generate the sample one with data exactly as in your post and desired result. It's worth to mention on which version of Excel you are. Hope @Riny_van_Eekelen make a correct guess, but with above chances to receive correct answer much higher. And faster.