Thread: 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.

    With WsChrt.ChartObjects("Chart 83").Chart
        .ChartType = xlLine
        .SetSourceData Source:=ChrtRng.Cells
        .PlotBy = xlRows
    End With