I have a problem when converting excel charts to images. When the chart type is Radar and the value type percent, the values on the value axis are multiplied with 100 (making 30% 3000%).
This happens ONLY when I convert the chart to image. When I execute the same code to produce an XLSX, everything is OK on the charts. It seems that sth happens during the conversion to image.
Here is the code that I use for XLSX, in order to set up the axis properly (this works fine for XLSX charts but not for the generated images of the same charts):
private void SetValueAxisStyles(Chart pChart, IExportCon pCont)
{
var lAxis = pChart.ValueAxis;
if (lAxis != null)
{
if (pCont.ValueType == ReportValueType.Percent)
{
lAxis.DisplayUnit = DisplayUnitType.Hundreds;
lAxis.IsDisplayUnitLabelShown = false;
lAxis.CategoryType = CategoryType.AutomaticScale;
lAxis.TickLabels.NumberFormat = “0%”;<span style="color:green;">// Charts with percentage values must have a scale up to 100% (no less).</span> lAxis.IsAutomaticMaxValue = <span style="color:blue;">false</span>; lAxis.IsAutomaticMinValue = <span style="color:blue;">false</span>; lAxis.MaxValue = 100.0f; lAxis.MinValue = 0.0f; lAxis.DisplayUnit = <span style="color:#2b91af;">DisplayUnitType</span>.Hundreds; } } }</pre><pre style="font-family: Consolas; background-position: initial initial; background-repeat: initial initial;">Can you tell me why this code doesn't work on the radar chart images and what code I should use instead?I had a similar problem in the past and I’ve solved it by setting the value of a property (the image converter used different default values?).
But here I don’t think I have left a related property unset…
Thanks,
Kostas