[Solved] Column Diagrams

[saleem145]

Hello,

I enter the following data into a spreadsheet

Audi 10
Mercedes 100
Porsche 5
VW 200
BMW 150

Make a Column Chart. The xlabels are set to Audi, Mercedes.... and there are neat bars. All is good.

Now enter the following data

1 10
2 100
3 5
4 200
5 150

Instead of using the first columns as xlabels, it plots two series of bars?? How can I force it to use the first series as xlabels??

And now how can I do this programatically. I am creating an instance of "com.sun.star.chart.ColumnDiagram". How do I specify the xlabels and the heights programatically. If I just call setData and pass in a 2D array it assumes there are two series of points and plots two series of bars.

Thanks,

Saleem

[saleem145]

chartData = chartDoc.getData()
chartData.setRowDescriptions(tuple(centers))

does the trick. Thanks.