ZackFuerth
New Member
- Joined
- Aug 24, 2022
- Messages
- 2
- Office Version
- 2021
- Platform
- Windows
Hello Everyone,
I am a mechanical graduate student working with the processing of large volumes of data. I am new to learning VBA and was curious if there is a way for a VBA code to be constructed that utilizing indexing of table titles (test conditions) to then be plotted into an XY Scatter plot.
To elaborate more, I am looking to generate a code that first identifies a data range/array that contains three different tests, from this a more specific data range can be selected using a different input. For example, a testing rate of 0.01 contains tests 1-3, if possible I would like it to be integrated into an excel sheet such that one cell contains the desired testing rate and the following contains the desired test number. From these inputs a button can be pressed for the code to pull the X and Y data (last used row) to be plotted. Ideally, this can be done with 3-5 input box pairings for 3-5 plots on a single graph.
Any help is appreciated to let me know if this is possible and/or plausible.
I am a mechanical graduate student working with the processing of large volumes of data. I am new to learning VBA and was curious if there is a way for a VBA code to be constructed that utilizing indexing of table titles (test conditions) to then be plotted into an XY Scatter plot.
To elaborate more, I am looking to generate a code that first identifies a data range/array that contains three different tests, from this a more specific data range can be selected using a different input. For example, a testing rate of 0.01 contains tests 1-3, if possible I would like it to be integrated into an excel sheet such that one cell contains the desired testing rate and the following contains the desired test number. From these inputs a button can be pressed for the code to pull the X and Y data (last used row) to be plotted. Ideally, this can be done with 3-5 input box pairings for 3-5 plots on a single graph.
Any help is appreciated to let me know if this is possible and/or plausible.