I am trying to add data series to chart as a set of non continuous cells. In excel this is done like: A1;A3;A5. How to define data series in Aspose.Cells to do the same ?
When I try do it this way it interprets it as three different data series.
I have the following situation. Lets say I have a worksheet with chart let it be “Charts” worksheet. Then I have the “ChartData” worksheet on which is the data that I want to display on chart.
The data is placed in following cells: H1,H3,H5 on “ChartData” worksheet
When I add the series manually in Excel chart source data is saved as following: =‘ChartData’!$H$1;‘ChartData’!$H$3;‘ChartData’!$H$5
So I have one series with data from those cells.
The similar problem I have with category.
When I tried your solution with cells delimited by commas each of H1, H3, H5 cells were interpreted as different data series.
Could you advise me how to manage such situation to create chart with only one data series.