Add high low indicators

[Pieter van Kampen]

Hi,

I have a report that shows line chart. I would like to add high -low indicators, but I can't find how to provide the data. 

Currently the source is:

           var data = new object[testScales.Count+1][];

            for (var i = 0; i < testScales.Count+1; i++)

                data[i] = new object[3];

            data[0][0] = "";

            data[0][1] = examinerName;

            data[0][2] = Config.Settings.AppSettings.Site;

            for (var i = 0; i < testScales.Count; i++)

            {

                data[i + 1][0] = testScales[i].Scale;

                data[i + 1][1] = examinerAve[i];

                data[i + 1][2] = testmijAve[i];

            }

//Creates and Appends chart to the paragraph

            WChart chart = paragraph.AppendChart(data, 470, 300);

            chart.Legend.Position = OfficeLegendPosition.Top;

            // Sets chart type, title, and border values.

          

            chart.ChartTitle = "Gemiddelde Score";

            chart.ChartTitleArea.Size = 14;

           

            chart.ChartArea.Border.LinePattern = OfficeChartLinePattern.None;

            //Sets series type 

            chart.Series[0].SerieType = OfficeChartType.Column_Clustered;

            chart.Series[1].SerieType = OfficeChartType.Line_Markers;

            chart.PrimaryCategoryAxis.Title = "Schalen";

            chart.PrimaryValueAxis.Title = "Score";

The line values in this example are 4.9, 4.2, 4.5 and 8.7. In the document, you can see there is an extra series, 0.3, 0.7, 0.6, 1.0.  I would like to show these as stock hi lo indicators, so 4.9 + and - 0.3, 4.2 +/- 0.7 etc.

I could not find an example how you provide these data points. Can you give me a pointer?

Attachment: hilo_ce271050.zip

[Manikandan Ravichandran]

Hi Pieter,

We are currently working on your requirement. We will update you with complete sample which meets your requirement within 2 hours.

Regards,
Manikandan Ravichandran

[Manikandan Ravichandran]

Hi Pieter,

Thank you for your patience.

On further analysing, we don’t have any public APIs to show the High-low lines for chart element. Currently we are validating the feasibility to show the high-low lines in the chart, and we will update the details about this on 11^th March 2020.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran

[Manikandan Ravichandran]

Hi Pieter,

Thank you for your patience.

We have considered your requirement for the feature “High-low lines and Drop lines formatting support in word document with chart”. We have expedited the fix for this feature and provide the patch on 25th March 2020.

The status of this feature task can be tracked through the below link:
https://www.syncfusion.com/feedback/12664/high-low-lines-and-drop-lines-formatting-support-in-word-document-with-chart

Note: HighLowLines only supported in line, scatter and stock chart type in Microsoft word application. Once the feature included you can add high-low line between two-line series, and due to some limitation, highLowLines not preserved in chart to image conversion, please find details as below.

 

ChartType	HighLowLines  in Resave and scratch	HighLowLines in ChartToImage conversion for both Net Framework and. NetStandard platforms
Line	Supported	Not supported
Scatter	Supported	Not supported
Stock	Supported	Supported

Note: Kindly let us know the currently installed product version, so that we can provide patch in that version based on our SLA policy.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran

[Preethi Nesakkan Gnanadurai]

From: Pieter van Kampen . 

 

Hi Manikandan Ravichandran, 

Thank you very much. 

I am currently using Syncfusion.DocIO.NET.Core, so NETStandard via Nuget, v17.4.0.55.  I can move to the latest version when you release the patch. 

 

No problem to not have the image conversion at this time. 

 

Kind regards 

 

Pieter van Kampen 

[Manikandan Ravichandran]

Hi Pieter,

Thank you for your update.

Since you are using our weekly NuGet version (v17.4.0.55) Syncfusion doesn’t support to provide patch for Weekly NuGet version. Instead of this, we will provide the customer assembly in the mentioned version in the promised date (25th March, 2020) and we have planned to include this feature in our 2020 Volume 2 Main release which will be available on end of June 2020 tentatively.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran

[Manikandan Ravichandran]

Hi Pieter,

Sorry for the inconvenience caused.

We are nearly at the end of releasing 2020 Volume 1 Main release and it is under testing phase. So, we unable to provide the patch for this feature. Since, Our 2020 Volume 1 release is estimated to be available by next week, so we have planned to include this fix in our 2020 Volume 1 Main release is estimated to be available on 31^st March 2020.

Please let us know if you have any other questions.

Regards,
Manikandan Ravichandran

[Pieter van Kampen]

No problem, be safe.

[Pieter van Kampen]

Can you confirm this feature is included in V18.1.0.42? 

Is there a sample or description available?

Thanks

Pieter

[Manikandan Ravichandran]

Hi Pieter,

Thank you for your patience.

We are glad to announce that our Essential Studio 2020 Volume 1 Release v18.1.0.42 is rolled out and is available for download under the following link.

https://www.syncfusion.com/forums/152921/essential-studio-2020-volume-1-release-v18-1-0-42-is-available-for-download.

As mentioned earlier, we have implemented the feature with “High-low lines and Drop lines formatting support in word document with chart” and included in this release.

Please refer the code example to set high low lines in chart.

 

//Creates a new Word document
WordDocument document = new WordDocument();
//Adds section to the document
IWSection sec = document.AddSection();
//Adds paragraph to the section
IWParagraph paragraph = sec.AddParagraph();
//Inputs data for chart
object[][] data = new object[6][];
for (int i = 0; i < 6; i++)
{
   data[i] = new object[3]; 

}
   data[0][0] = "";
   data[1][0] = "Camembert Pierrot";
   data[2][0] = "Alice Mutton";
   data[3][0] = "Roasted Tigers";
   data[4][0] = "Orange Shake";
   data[5][0] = "Dried Apples";
   data[0][1] = "Sum of Purchases";
   data[1][1] = 286;
   data[2][1] = 680;
   data[3][1] = 288;
   data[4][1] = 200;
   data[5][1] = 731;
   data[0][2] = "Sum of Future Expenses";
   data[1][2] = 1300;
   data[2][2] = 700;
   data[3][2] = 1280;
   data[4][2] = 1200;
   data[5][2] = 2660;
   //Creates and Appends chart to the paragraph
   WChart chart = paragraph.AppendChart(data, 470, 300);
   //Sets chart type and title
   chart.ChartTitle = "Purchase Details";
   chart.ChartTitleArea.FontName = "Calibri";
   chart.ChartTitleArea.Size = 14;
   chart.ChartArea.Border.LinePattern = OfficeChartLinePattern.None;
   //Sets series type
   chart.Series[0].SerieType = OfficeChartType.Line_Markers;
   chart.Series[1].SerieType = OfficeChartType.Line_Markers;
   chart.PrimaryCategoryAxis.Title = "Products";
   chart.PrimaryValueAxis.Title = "In Dollars";
   //Sets position of legend
   chart.Legend.Position = OfficeLegendPosition.Bottom;
   chart.Series[0].SerieFormat.CommonSerieOptions.HasHighLowLines = true;
   chart.Series[0].SerieFormat.CommonSerieOptions.HighLowLines.LineColor = Color.Blue;
   //Saves the document
   document.Save("Sample.docx", FormatType.Docx);
   //Closes the document
   document.Close(); 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards
Manikandan Ravichandran