valenmartinez35
New Member
- Joined
- May 20, 2019
- Messages
- 1
I am trying to automatically add series using VBA. I have a list of values that I want to graph and I want to see if I can automatically do it based on different values. My graph would be column K as the x-axis; column J as the y-axis and column B as my series names and pulling data from them. As right now I have been doing this manually, but I am sure theres a faster way to do it using macros.
<tbody>
</tbody>
B-Column | J-Column | K-Column |
405 | 1 | 1 |
405 | 11 | 2 |
406 | 2 | 1 |
385 | 3.5 | 1 |
385 | 3.4 | 2 |
566 | 0.92 | 1 |
566 | 8.6 | 2 |
<tbody>
</tbody>