Chart Value labels in Radar chart

[Pieter van Kampen]

Hi,

I have the following stacked Radar chart in a Word Document, created using DocIo in Asp.Net Core. The category labels are on the outer edge of the radar chart and correctly displaying as text. However, the value labels are displayed as 0 to 7, in the middle of the chart. I would like to display labels there too. 0= "", 1= "very low", 2="low", etc.

I have these labels in the chart data:chart.ChartData[1, 6, scoreTable.Count + 1, 6]

How can I add these to the chart instead of these numbers?

Thanks,

Pieter

[Sethumanikkam Yogendran]

Hi Pieter,

Thank you for contacting Syncfusion support.

How can I add these to the chart instead of these numbers?
On further analyzing with the given details, we found that your requirement is to set text for the value axis in the radar chart. As per Microsoft Office chart behavior, value axis only shows the numeric values and radar chart only has value axis. There’s no category axis for radar chart.

So, it is not possible to set values other than numeric for value axis in the radar chart.

If we misunderstood any of your requirement, then kindly update us your requirement with sample for clear description along with input document (if any) and screenshot/output Word document of the expected result which will helpful to provide you the appropriate solution at the earliest.

Please let us know if you have any other questions.

Regards,
Sethumanikkam.Y

[Pieter van Kampen]

Thanks, that is clear. You understood my requirement.

Do you think either of these alternatives is possible?

a) place a text box over the graph with a value axis legend:

or b) remove the value axis altogether

Pieter

[Sethumanikkam Yogendran]

Hi Pieter,

Thank you for your update.

a) place a text box over the graph with a value axis legend:
We regret to let you know that the support for “add textbox/shape within the chart” is not yet implemented and we have already logged this as a feature request in our database. We will implement this feature in any of our upcoming releases. The feature implementation would also greatly depend on the factors such as product design, code compatibility and complexity. We will let you know once this feature has been implemented.

b) remove the value axis altogether:
You can remove/hide the value axis from radar chart by changing the label position. Please refer the below code snippet, and let us know if this helps you. 

chart.PrimaryValueAxis.TickLabelPosition = OfficeTickLabelPosition.TickLabelPosition_None; 

Please let us know if you have any other questions.

Regards,
Sethumanikkam.Y

[Pieter van Kampen]

Hello,

Has this changed? Is it now possible to add text labels rather than numeric in the value axis in the radar chart?

Thanks Pieter

[Hemalatha Chiranjeevulu]

Hi Pieter,

Thank you for your update.

Currently, we are checking with corresponding team. We will check and update you with more details on 27^th July 2021.

Please let us know if you have any other questions.

Regards,
Hemalatha C

[Hemalatha Chiranjeevulu]

Hi Pieter,

Thank you for your patience.

As we mentioned earlier, Essential DocIO does not have support to add textbox/shape in chart in Word document. We need some time to analyze the Microsoft Word behavior of adding textbox/shape in chart. Currently we are analyzing on to provide support to add textbox/shape in chart in the Word document and we will update you with more details on 29^th July 2021.

Please let us know if you have any other questions.

Regards,
Hemalatha C

[Hemalatha Chiranjeevulu]

Hi Pieter,

Thank you for your patience.

Currently, we don’t have support for shapes/textbox with in the chart. We have already logged this as a feature request in our database and we don’t have any immediate plans to implement this feature. At the planning stage for every release cycle, we review all open features. We will let you know when this feature is implemented.

The status of this feature can be tracked using following feedback link
https://www.syncfusion.com/feedback/27412/support-to-add-shape-within-chart-for-word-or-presentation-document

As a workaround, we suggest you to add textbox and move over the chart using below code example

 

WordDocument document = new WordDocument(); 

document.EnsureMinimal(); 

//Adds chart to the slide with position and size 

WChart chart = document.LastParagraph.AppendChart(500, 300); 

chart.ChartType = OfficeChartType.Radar; 

//Assign data 

chart.DataRange = chart.ChartData[1, 1, 6, 2]; 

chart.IsSeriesInRows = false; 

//Set data to the chart RowIndex, columnIndex and data 

chart.ChartData.SetValue(1, 1, "Food"); 

chart.ChartData.SetValue(1, 2, "Count"); 

chart.ChartData.SetValue(2, 1, "Fruits"); 

chart.ChartData.SetValue(3, 1, "Vegitables"); 

chart.ChartData.SetValue(4, 1, "Dairy"); 

chart.ChartData.SetValue(5, 1, "Proptein"); 

chart.ChartData.SetValue(6, 1, "Grains"); 

chart.ChartData.SetValue(1, 2, "Percentage"); 

chart.ChartData.SetValue(2, 2, "36"); 

chart.ChartData.SetValue(3, 2, "14"); 

chart.ChartData.SetValue(4, 2, "13"); 

chart.ChartData.SetValue(5, 2, "28"); 

chart.ChartData.SetValue(6, 2, "9"); 

//Apply chart elements 

//Set chart title 

chart.ChartTitle = "Radar Chart"; 

//Set legend 

chart.HasLegend = false; 

//Set Datalabels 

IOfficeChartSerie serie = chart.Series[0]; 

serie.DataPoints.DefaultDataPoint.DataLabels.IsValue = true; 

//Add textbox 

IWTextBox textbox = document.LastParagraph.AppendTextBox(120, 100); 

textbox.TextBoxFormat.TextWrappingStyle = TextWrappingStyle.InFrontOfText; 

//Sets horizontal and vertical position for textbox 

textbox.TextBoxFormat.HorizontalPosition = 370; 

textbox.TextBoxFormat.VerticalPosition = 160; 

//Adding text to textbox 

IWParagraph paragraph = textbox.TextBoxBody.AddParagraph(); 

IWTextRange textRange = paragraph.AppendText("5 - Very low"); 

textRange.CharacterFormat.FontName = "Calibri"; 

textRange.CharacterFormat.FontSize = 11; 

paragraph = textbox.TextBoxBody.AddParagraph(); 

textRange = paragraph.AppendText("10 - Low"); 

textRange.CharacterFormat.FontName = "Calibri"; 

textRange.CharacterFormat.FontSize = 11; 

paragraph = textbox.TextBoxBody.AddParagraph(); 

textRange = paragraph.AppendText("15 - High"); 

textRange.CharacterFormat.FontName = "Calibri"; 

textRange.CharacterFormat.FontSize = 11; 

paragraph = textbox.TextBoxBody.AddParagraph(); 

textRange = paragraph.AppendText("40 - Very High"); 

textRange.CharacterFormat.FontName = "Calibri"; 

textRange.CharacterFormat.FontSize = 11; 

document.Save("Sample.docx"); 

Please let us know if you have any other questions.

Regards,
Hemalatha C