Graphing Data from a Filtered Column [Closed]

Report
Posts
1
Registration date
Thursday October 27, 2016
Status
Member
Last seen
October 27, 2016
-
I am currently graphing a lot of data that I look at on a scatter plot. I have a column that is named "Step name " that has about 30 different steps during a dynamic test that data is collected that I want to look at. But I filter them with the filter command. Then I have the whole column and do a scatter plot to see a trend over time against all test run. Then i can change the filter to see a different step and so on. but i can only get 1 graph. I have not been able to find a way to make a macro or template that will allow me to take each step and make its own seperate graph on a different tab so i can see what it looks like by just changing tabs. I have to change the filter. I havent been in VBA for years and it shows. The other thing is I have tried to make multiple graphs. BUt when I change the filter It changes the graph. Sorry if this is simple.




Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!