Forum Discussion
New to Excel formulas
I need the proper formula for taking data from several cells on one sheet and moving them to a different sheet to be used on a chart, any help would be appreciated.
Unfortunately I cannot upload the work book, but
12.5 | 20.0 | 30.0 | 40.0 | 50.0 | 60.0 | 70.0 | 80.0 | 90.0 | 100.0 |
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
28.0 | 34.0 | 42.0 | 52.0 | 62.0 | 74.0 | 84.0 | 93.0 | 100.0 | 115.0 |
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.