+ Reply to Thread
Results 1 to 1 of 1

UserForm/Chart Issues

  1. #1
    Registered User
    Join Date
    06-27-2014
    Location
    Arkansas
    MS-Off Ver
    365
    Posts
    57

    UserForm/Chart Issues

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Having issues with plotting my data in a chart, any chart!!
    By rendalli in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-15-2015, 04:31 PM
  2. [SOLVED] Radar Chart - series chart type conversion issues
    By Prince Dakkar in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-20-2015, 08:44 AM
  3. [SOLVED] Userform Issues
    By Rosco88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2015, 09:24 AM
  4. Userform issues
    By xia0jj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 03:13 AM
  5. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  6. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  7. UserForm-Listbox-Issues, Data To & From Excel Cells Not Working; Null Values
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2013, 12:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1