We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Unable to edit chart data manually in word chart/ using Aspose.Word for .Net 15.6.0

Hi there,

Using Aspose.Word for .Net 15.6.0, I am creating a chart form scratch. To create chart, I have copied the code from your below given URL:

https://docs.aspose.com/words/net/working-with-charts/

I want to edit chart data in Excel and to do that when I right click on chart and click “Edit Data”, it doesn’t open related excel file containing chart data. I have attached generated .docx file for your help. Please look into this.

Code:

private void CreateChart()
{
    Document doc = new Document();
    DocumentBuilder builder = new DocumentBuilder(doc);

    // Add chart with default data. You can specify different chart types and sizes.
    Shape shape = builder.InsertChart(ChartType.Column, 432, 252);

    // Chart property of Shape contains all chart related options.
    Chart chart = shape.Chart;

    // Get chart series collection.
    ChartSeriesCollection seriesColl = chart.Series;

    // Delete default generated series.
    seriesColl.Clear();

    // Create category names array, in this example we have two categories.
    string[] categories = new string[] { "AW Category 1", "AW Category 2" };

    // Adding new series. Please note, data arrays must not be empty and arrays must be the same size.
    seriesColl.Add("AW Series 1", categories, new double[] { 1, 2 });
    seriesColl.Add("AW Series 2", categories, new double[] { 3, 4 });
    seriesColl.Add("AW Series 3", categories, new double[] { 5, 6 });
    seriesColl.Add("AW Series 4", categories, new double[] { 7, 8 });
    seriesColl.Add("AW Series 5", categories, new double[] { 9, 10 });

    doc.Save(DataDir + @"TestInsertChartColumn.docx");

}

Hi Kavita,

Thanks for your inquiry. We tested the scenario and have managed to reproduce the same problem on our end. For the sake of any correction, we have logged this problem in our issue tracking system as WORDSNET-12092. Our product team will further look into the details of this problem and we will keep you updated on the status of correction. We apologize for any inconvenience.

Best regards,

Hello,

I have the same problem.
Have you resolved the problem by other way ?

Thank you for your answer.

Alida

Hi Alida,

Thanks for your inquiry.

This problem (WORDSNET-12092) actually requires us to implement a new feature in Aspose.Words and we regret to share with you that implementation of this issue has been postponed for now. However, the fix of this problem may definitely come onto the product roadmap in the future. Unfortunately, we can not currently promise a resolution date. We apologize for your inconvenience.

Also, please follow your other thread for further proceedings.

Best regards,