Excel Forum Sample of Screw and Barrel Log.xlsx
Hello all,
I have a workbook with multiple sheets that I would like to have a line graph for each sheet create automatically. The number of columns and rows are not the same on all sheets. The number of columns used will change for each sheet. So one sheet can use 1 column, another sheet can have 3 columns, and another can have 15 columns. The rows on each sheet will be different, but shouldn't change.
The only constants are that the date will always be in row 2, and the data used will always start in row 7. The horizontal axis will always start in A7 but may only go to row 33, 34, 35 or a lower or higher row.
In the workbook I have manually created the graphs for the 14A Screw, 14B Screw and 14B Barrel sheets. If someone could show me the way to get the 14A Barrel sheet to automatically create the line graph, I should be able to get it to work for all the other sheets as well (I hope).
Thanks to all that have helped me in the past, and thanks in advance to those that help me with this.
Bookmarks