SetSourceData Does not Set Consistently

Hi all,

I have a couple of problems with my charting project (See attached). When you open the workbook, you'll see the button "Reset" which activates a UserForm. If you pick 5 or less indecies (value names), the chart displays it properly with the index names on the right side that represent all of the series collections. However, if you pick 5 or more, the index names move horizontally on the bottom of the chart, which is not the way I want the chart formatted. I don't know why it is doing this. Also, the list boxes act peculiarly because I have (sometimes) double click them to select a value or, when I do click a value, more than one will be selected. Again, I don't know why this would be happening. There is a lot of code and I'm sorry for that as I don't want make this difficult for you but I have been trying to do this on my own and I am completely stumped! Please help!

Regards:

Excel will guess whether to plot by rows or columns depending on data and size of the matrix.

Explicitly set the PlotBy to avoid bad guessing.

Please Login or Register  to view this content.