autofill question
Hi all.
I have to make a surface graph using data that is placed 34 rows apart for each piece of data. Is there a way to autofill the data into a different sheet to easily create the graph? Example Row 1 - X 1, Y 1, Data Row 3 - X 1, Y 2, Data Row 5 - X 1, Y 3, Data Row 7 - X 2, Y 1, Data Row 9 - X 2, Y 2, Data Row 11 - X 2, Y 3, Data Row 13 - X 3, Y 1, Data Row 15 - X 3, Y 2, Data Row 17 - X 3, Y 3, Data Thanks! |
All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com