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 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago