UserForm Help
Hello,
I am creating a form with check boxes to be able to choose certain data sets to compare data. I have some of it figured out but, what I am getting trouble with is adding multiple series to the scatterplot. I can add multiple but the series are listed as 1 series 2 series 3. I have 10 x 9 check boxes and want them to be able to all appear on the chart if selected (so 90 different series could be created). So as you can imagine if series one checkbox is not checked and series 2 and 3 are it gives an invalid parameter error because the chart thinks it should be series one. I think doing some sort of n+1 or I +1 will be the solution but I ma not very familiar with this type of programming. I have attached the file. The form I am working on is GraphMaker and can be accessed using the "Show Form" button on the "Graphs" worksheet. Any help or suggestions would be appreciated.
Attachment | Size |
---|---|
New_Tower Monitoring.xlsm | 109.19 KB |
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago