ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   autofill question (https://www.excelbanter.com/excel-discussion-misc-queries/15674-autofill-question.html)

Ben H

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