Chart Using Value List

[rich.barry]

The quickest way of getting my data into a chart is hopefully going to be passing a value list to the RowSource using code.

The problem is, I can't quite work out the syntax for the RowSource property.
All I want is a bar graph where I sent eg 1;2;3;4 and it plots 4 bars all belonging to the same series.
The closest I can get that seems to work is sending:

rubbish;rubbish;rubbish;1;rubbish;2;rubbish;3;rubbish;4

where I have the column count set to 2 and column heads on. Even then I get 4 series, not 1.

Anyone know the correct way?

Thanks

Richard

 

[sneuberg]

Better late then never. Through experimentation I found that the value list fills in the chart's datasheet row by row, i,e, the values fill in the first row up to the column count and then go to the second row. The thing that might throw you off is the the first row contains the legend names, albeit I haven't determined what the first cell is used for. The following example should help you figure out how to format the value list.

For a column count of 2 and value list of 0;Legent;Y1;1;Y2;2;Y3;3;Y4;4 the resulting bar chart looks like

and the chart's datasheet looks like:

For a column count of 3 and a value list of 0;Legent1;Legent2;Y1;1;2;Y2;3;4;Y3;5;6 the result bar chart looks like:

and the chart's datasheet looks like:

Yeah, I know, Legend is spelt with a d.