PurpleGatsby
New Member
- Joined
- Oct 5, 2017
- Messages
- 1
I have large amounts of data and would like to cut time down by not having to sift through it manually. Essentially, my the data in interest involves temperature and flow rate. I would like to be able to write a macro to create line graphs. But I want the macro to be able to sort through the data and only plot a specific range. Here is an example of the data: https://nofile.io/f/untsxEGv4QO/01-Hysteresis-28JL17.xlsx
Essentially, the test cycles 3 times in total, meaning I need three graphs. I want to plot the graphs as temperature vs flow rate, but I only want to plot when the temperature is between 80*C and 105*C. So I want my macro to identify each time the range occurs and then plot it. Is this something that is doable with vba?
Essentially, the test cycles 3 times in total, meaning I need three graphs. I want to plot the graphs as temperature vs flow rate, but I only want to plot when the temperature is between 80*C and 105*C. So I want my macro to identify each time the range occurs and then plot it. Is this something that is doable with vba?
