Retain Lines between Data Points in Scatter Chart | Combo Custom Combination Chart in Word Document (C# .NET)

Aspose.Words Product Family
1

Hi,

In our company, we have a simple docx with a Scatter chart connected by lines in it.
The chart has already been setup with all the styles, etc that are needed.
All we need to automate is a push into the chart of new data value.
When we clear the series data and push new series data, the connection between the charts points disappears.
We have a similar issue with combinated charts also.
After investigation we figured out the these Charts types are not actually supported by Aspose.Words API.
Do you plan to implement these features in the near future ?

Thanks

2

@toureelhadj,

To ensure a timely and accurate response, please ZIP and attach the following resources here for testing:

  • Your simplified source Word document containing the preconfigured Scatter Chart with Lines
  • Aspose.Words for .NET 21.1 generated output DOCX file showing the undesired behavior
  • Your expected DOCX file showing the desired output. You can create this document manually by using MS Word.
  • Please also create a standalone simple Console application (source code without compilation errors) that helps us to reproduce your current problem on our end and attach it here for testing. Please do not include Aspose.Words DLL files in it to reduce the file size.

As soon as you get these pieces of information ready, we will start further investigation into your issue and provide you more information.

4

Hi,

Here the zip containing two projects using Aspose.Words for .NET 21.1:

  • ScatterSample
  • CombinatedChartSample

For ScatterSample, the chart is updated but the line between the points disappears and the Excel containing chart data is not updated.
For CombinatedChartSample, the program will corrupt the document.

Best regards
ChartsSample.zip (40.8 KB)

5

@toureelhadj,

We have logged the following problems in our issue tracking system:

  • WORDSNET-21732: Lines between Data Points Disappear when updating a Scatter Chart with Smooth Lines
  • WORDSNET-21733: Combo Custom Combination Chart - Updating a Combinated Chart Corrupts Document

We will further look into the details of these problems and will keep you updated on the status of linked issues. We apologize for your inconvenience.

6

Hi,

Thank you for your quick reply. Do you have an approximate date of resolution of these tickets ?

Best regards

7

@toureelhadj,

WORDSNET-21732 and WORDSNET-21733 are currently pending for analysis and are in the queue. We will inform you via this forum thread as soon as these issues will get resolved in future or any timeframes (ETA) may be available. We apologize for any inconvenience.

8

The issues you have found earlier (filed as WORDSNET-21733) have been fixed in this Aspose.Words for .NET 21.4 update and this Aspose.Words for Java 21.4 update.

9

Hello,

Thank you for your feedback, we have tested the new .NET 21.4 update about WORDSNET-21733, but unfortunately it does not meet our needs.
As you can see from the sample attached to this topic, the combined chart contains two series, a column series and a line series.
Our need is to replace the data from both series with new data.
But we note that only the chart of the first series is impacted. Indeed instead of having two series in the final document, we note that there are three, two column series and a line series which is not modified.

Best regards

10

@toureelhadj,

We have logged these details in our issue tracking system and will keep you posted here on any further updates.

11

@toureelhadj,

Regarding WORDSNET-21732, please use the following code to get the same view of the series as in the original document:

Document document = new Document("C:\\Temp\\ScatterSample\\Sample.docx");

var now = DateTime.Now;
var xValues = new DateTime[]
{
   now,
   now.AddDays(1),
   now.AddDays(2),
   now.AddDays(3),
   now.AddDays(4)
};

var yValues = new List<double[]>
{
   new double[] { 1, 4, 2, 7, 5 },
   new double[] { 2, 7, 6, 3, 10 }
};

var colors = new List<Color>
{
   Color.FromArgb(255, 91, 155, 213),
   Color.FromArgb(255, 237, 125, 49)
};

UpdateChart(document, 0, xValues, yValues, colors);

document.Save("C:\\Temp\\ScatterSample\\21.6.docx");

private static void UpdateChart(Document document, int chartIndex, DateTime[] xValues, List<double[]> yValues, List<Color> colors)
{
    var shape = (Shape)document.GetChild(NodeType.Shape, chartIndex, true);
    if (shape.HasChart)
    {
        Chart chart = shape.Chart;
        chart.Series.Clear();

        for (var i = 0; i < yValues.Count; i++)
        {
            ChartSeries series = chart.Series.Add($"Series {i + 1}", xValues, yValues[i]);

            series.Format.Stroke.Color = colors[i];
            series.Smooth = true;
            series.Marker.Symbol = MarkerSymbol.None;
        }
    }
}
12

The issues you have found earlier (filed as WORDSNET-21732) have been fixed in this Aspose.Words for .NET 21.10 update also available on NuGet.