I am creating a graph with a macro. I cannot create a graph with multiple data in the horizontal direction.
When I create the graph, I am not sure how to use the macro.
I can’t find a macro that does the same thing as when I select a series of data in a row in a range of data.
I have searched a lot, but all I can find are explanations for creating a graph from data in columns.
Example
oRangeAddress(0).StartColumn = 4
oRangeAddress(0).StartRow = 29
oRangeAddress(0).EndColumn = 21
oRangeAddress(0).EndRow = 29
oRangeAddress(1).StartColumn = 0
oRangeAddress(1).StartRow = 12
oRangeAddress(1).EndColumn = 13
oRangeAddress(1).EndRow = 12
oRangeAddress(2).StartColumn = 0
oRangeAddress(2).StartRow = 12 +8
oRangeAddress(2).EndColumn = 13
oRangeAddress(2).EndRow = 12 +8
oCharts.getByname(oTitle).setRanges(oRangeAddress)
oChart = oCharts.getByName(oTitle).getEmbeddedObject()
oChart.Diagram = oChart.createInstance("com.sun.star.chart.AreaDiagram")
I can get it to work for data in columns, but not for data in rows.
Please help.
I want to create this.
Translated with www.DeepL.com/Translator (free version)