Free Support Forum - aspose.com

Chart series edit issue

When I am trying to edit the chart series. Series become disappear in excel.
Can you please let me know what is the reason? What will be the solution?

@amitahlawat,

Thanks for providing us some details.

I am not sure about your issue. Are you opening the output file (containing the chart) into MS Excel generated by Aspose.Cells APIs? How did you create the file, kindly share a sample console demo application (runnable) and template file(s) to evaluate your issue precisely. Also, provide some screenshots to highlight the issue, we will check it soon.

PS. Please try using our latest version/fix: Aspose.Cells v18.8.x.

Untitled.png (38.1 KB)

fact.Clear(defaultWorksheetIndex); // Clear All Data of DataChart
fact.GetCell(defaultWorksheetIndex, 2 + colstart, 0).Value = serName1; // put series Name in datachart
fact.GetCell(defaultWorksheetIndex, 3 + colstart, 0).Value = serName2;// put series Name in datachart
// Remove Categories from DataChart
for (int i = catCount - 1; i >= 0; i–)
{
chart.ChartData.Categories.RemoveAt(i);
}
// Remove Series from DataChart
for (int j = seriesCount - 1; j >= 0; j–)
{
for (int i = catCount - 1; i >= 0; i–)
{
chart.ChartData.Series[j].DataPoints.RemoveAt(i);
}
}

            // Add new Categories and series from DataChart with fill the data
            for (int i = 0; i <= dtRowsCount; i++)
            {
                IChartSeries ser = null;
                if (i != dtRowsCount)
                {
                    DataRow dr = dt.Rows[i];
                    var cell12 = fact.GetCell(defaultWorksheetIndex, i + 1, 0, "");
                    cell12.Value = dr[0];
                    var drRef = reversedDt.NewRow();
                    reversedDt.Rows.Add(drRef);
                    reversedDt.Rows[i][0] = dr[0];
                    chart.ChartData.Categories.Add(cell12);
                    for (int j = 1; j < dt.Columns.Count - 2; j++)
                    {
                        cell12 = fact.GetCell(defaultWorksheetIndex, i + 1, j + 1);
                        cell12.Value = Convert.ToDecimal(dr[j].ToString());
                        reversedDt.Rows[i][j] = Convert.ToDecimal(dr[j].ToString());
                        ser = chart.ChartData.Series.Where(x => dt.Columns[j].ToLower().Contains(x.Name.ToLower())).FirstOrDefault();
                        if (ser == null)
                            ser = chart.ChartData.Series[j - 1];
                        ser.NumberFormatOfXValues = "0%";
                        AsposeUtil.AddDataPoint(ser, cell12, ser.Type);
                    }
                }
	}

@amitahlawat,

Thanks for the screenshot and code segment.

I have checked your screenshot and sample code segment, Well, since you are manipulating charts in PowerPoint presentation and using Aspose.Slides APIs, so you should post your issue with details and samples in Aspose.Slides forum, one of our fellow colleagues will help you there. I am afraid, I can only help you with issues regarding Aspose.Cells APIs.