Sorry - my post was too quick: I just found it
Sub Main
oSheet = ThisComponent.sheets.getByIndex(0)
oChart = oSheet.Charts.getByIndex(0)
oCoordSys = oChart.EmbeddedObject.FirstDiagram.CoordinateSystems(0)
oChartType = oCoordSys.ChartTypes(0).createClone
oChartType.GapwidthSequence = Array(10,10)
oChartType.OverlapSequence = Array(10,10)
oCoordSys.setChartTypes(Array(oChartType))
End Sub
----- Original Message -----
From: "Martin S" <[email protected]>
To: <[email protected]>
Sent: Tuesday, May 19, 2009 11:29 PM
Subject: [dev] GapWidth and Overlap for bar charts in OO 3.1
Hi,
is there any possibility to set GapWidth and Overlap for Bar Charts in the
new chart engine ? I tried the following for a simple bar diagram with two
data series:
Sub Main
oSheet = ThisComponent.sheets.getByIndex(0)
oChartShape = oSheet.DrawPage.getByIndex(0)
oChartObject = oChartShape.EmbeddedObject.Component
msgbox oChartObject.Diagram.XAxis.getPropertyValue("GapWidth") 'returns
nothing
oChartObject.Diagram.XAxis.setPropertyValue("GapWidth", 30)
msgbox oChartObject.Diagram.XAxis.getPropertyValue("GapWidth") 'returns
30, but no effect in the chart
msgbox oChartObject.Diagram.XAxis.getPropertyValue("Overlap") 'returns
nothing
oChartObject.Diagram.XAxis.setPropertyValue("Overlap", 30)
msgbox oChartObject.Diagram.XAxis.getPropertyValue("Overlap") 'returns 30,
but no effect in the chart
End Sub
I did not find any properties in chart2 / FirstDiagram ...
ms777
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
