I am presenting a simple 2d array of values in VBA (which is variable in size) and get different graph formats for the same graph style depending on the number of columns. For example, this data:

Ave Set1 Set2 Set3 ...... Set10
C1 7.5 7.0 6.0 6.5 4.0
C2 7.5 7.5 7.5 7.5 6.0
C3 7.5 8.0 9.0 8.5 5.0

which is a 2d array (C1/Ave/7.5 are one cell, C1/Set10/4.0 are another cell etc) displays a perfect line graph with the decimal values as the 'y' values, C1 to C3 as the 'x' axis and Ave, Set1 to Set10 as the Legend.

If I add a new Set, say Set11, the graph format changes so C1 to C3 become the Legend and Ave, Set1 to Set11 become the 'x' axis. Please Help!