Hi
Is it possible to set interpolation of empty cells in data chart? This option is possible in Aspose.Cells and it is called PlotEmptyCellsType.Interpolated but in Aspose.Slides I cannot find any similar functionality.
Best regards,
Chris
Hi
Best regards,
Chris
Hi
Chris,
Ok, so I’ll send you two sample files that show the best of what functionality I’m talking about. In one file there is data series which the dots are not connected with lines (because there are gaps in chart data). Second file is what I want to get - data series with connected points.
Hi Chris,
public static void AddLineCharts(){PresentationEx pres = new PresentationEx();SlideEx slide = pres.Slides[0];ChartEx chart = slide.Shapes.AddChart(ChartTypeEx.LineWithMarkers, 20, 20, 400, 400);ChartDataEx chData=chart.ChartData;chData.Series.Clear();chData.ChartDataCellFactory.Clear(0);int defaultWorksheetIndex = 0;//Getting the chart data worksheetChartDataCellFactory fact = chart.ChartData.ChartDataCellFactory;int id=chData.Series.Add(fact.GetCell(defaultWorksheetIndex, 0, 1, “Test”), chart.Type);//Adding new categorieschart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 1, 0, “Cat 1”));chart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 2, 0, “Cat 2”));chart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 3, 0, “Cat 3”));chart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 4, 0, “Cat 4”));chart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 5, 0, “Cat 5”));chart.ChartData.Categories.Add(fact.GetCell(defaultWorksheetIndex, 6, 0, “Cat 6”));//Take first chart seriesChartSeriesEx series = chart.ChartData.Series[id];//Now populating series dataseries.Values.Add(fact.GetCell(defaultWorksheetIndex, 1, 1, 20));series.Values.Add(fact.GetCell(defaultWorksheetIndex, 2, 1, String.Empty));series.Values.Add(fact.GetCell(defaultWorksheetIndex, 3, 1, 30));series.Values.Add(fact.GetCell(defaultWorksheetIndex, 4, 1, 10));series.Values.Add(fact.GetCell(defaultWorksheetIndex, 5, 1, String.Empty));series.Values.Add(fact.GetCell(defaultWorksheetIndex, 6, 1, 40));// Save presentation with chartpres.Write(@“D:\Aspose Data\AsposeChart.pptx”);}
Hi Chris,
chart.DisplayBlanksAs = DisplayBlanksAsTypeEx.Span;