Excel Chart : Floor property doesn''t work

[Vinod K Bobba]

Hi,

I am trying to get the Floor lines working for Column_3D chart.

It throws me an error that,
"System.ApplicationException: Floor is not supported by this chart type."

Is there any other way to get the floor lines for this chart or am I missing something?

Please let me know.

Code Below:
IChartShape chart = sheet.Charts.Add();

chart.ChartType = ExcelChartType.Column_3D;

chart.ChartArea.Fill.Visible = true;

chart.ChartArea.Fill.BackColor = Color.Gainsboro;

chart.Floor.LineProperties.LinePattern = ExcelChartLinePattern.MediumGray;


Thank you,
Vinod.

[Lokesh R]

Hi Vinod,

Thank you very much for your interest on Syncfusion products.

I am afraid that i could not able to reproduce the reported issue at our side. I have created a sample with reference to the code snippet posted in your last update and tested the sample with our latest assemblies 8.2.0.18 Ver(Volume 2Release), Could you please get and try the sample with the assemblies from the attachment and let us know if this solves your issue and for your reference, i have added the chart types that supports the Floor property.

ExcelChartType.Column_3D,
ExcelChartType.Column_Clustered_3D,
ExcelChartType.Column_Stacked_100_3D,
ExcelChartType.Column_Stacked_3D,
ExcelChartType.Bar_Clustered_3D,
ExcelChartType.Bar_Stacked_3D,
ExcelChartType.Bar_Stacked_100_3D,
ExcelChartType.Line_3D,
ExcelChartType.Area_3D,
ExcelChartType.Area_Stacked_3D,
ExcelChartType.Area_Stacked_100_3D,
ExcelChartType.Cylinder_Clustered,
ExcelChartType.Cylinder_Stacked,
ExcelChartType.Cylinder_Stacked_100,
ExcelChartType.Cylinder_Bar_Clustered,
ExcelChartType.Cylinder_Bar_Stacked,
ExcelChartType.Cylinder_Bar_Stacked_100,
ExcelChartType.Cylinder_Clustered_3D,
ExcelChartType.Cone_Clustered,
ExcelChartType.Cone_Stacked,
ExcelChartType.Cone_Stacked_100,
ExcelChartType.Cone_Bar_Clustered,
ExcelChartType.Cone_Bar_Stacked,
ExcelChartType.Cone_Bar_Stacked_100,
ExcelChartType.Cone_Clustered_3D,
ExcelChartType.Pyramid_Clustered,
ExcelChartType.Pyramid_Stacked,
ExcelChartType.Pyramid_Stacked_100,
ExcelChartType.Pyramid_Bar_Clustered,
ExcelChartType.Pyramid_Bar_Stacked,
ExcelChartType.Pyramid_Bar_Stacked_100,
ExcelChartType.Pyramid_Clustered_3D,
ExcelChartType.Surface_3D,
ExcelChartType.Surface_NoColor_3D

Please, let us know if you need more clarifications.

Thanks,
Lokesh



Forum-94004_9d414142.zip

[Andrei Gafton]

Hello,
I have the same problem. I'm trying to add major gridlines to the z-axis(the floor of the chart) of a Column_3d chart.
This is the code I'm using:

IChartFrameFormat chartArea = chart.ChartArea;
chartArea.Border.LinePattern = ExcelChartLinePattern.Solid;
chartArea.Border.LineColor = Color.Tan;
chartArea.Border.LineWeight = ExcelChartLineWeight.Hairline;
chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Category;

//chart.PrimaryCategoryAxis.TickLabelSpacing = 2;


chart.AutoScaling = false;
//chart.PrimaryCategoryAxis.LabelFrequency = 1;

chart.PrimaryCategoryAxis.Offset = 1;
chart.PrimarySerieAxis.ReversePlotOrder = true;

//chart.RightAngleAxes = true;

chart.Floor.LineProperties.LineWeight = ExcelChartLineWeight.Hairline;
chart.Floor.LineProperties.LineColor = Color.Gray;

chart.PrimaryCategoryAxis.HasMajorGridLines = true;
chart.PrimaryCategoryAxis.MajorGridLines.Border.LineColor = Color.Blue;
chart.PrimaryCategoryAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

chart.PrimaryValueAxis.HasMajorGridLines = true;
chart.PrimaryValueAxis.MajorGridLines.Border.LineColor = Color.Red;
chart.PrimaryValueAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

chart.PrimarySerieAxis.HasMajorGridLines = true;
chart.PrimarySerieAxis.MajorGridLines.Border.LineColor = Color.Gray;
chart.PrimarySerieAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

[Andrei Gafton]

Hello,
I have the same problem. I'm trying to add major gridlines to the z-axis(the floor of the chart) of a Column_3d chart.
This is the code I'm using:

IChartFrameFormat chartArea = chart.ChartArea;
chartArea.Border.LinePattern = ExcelChartLinePattern.Solid;
chartArea.Border.LineColor = Color.Tan;
chartArea.Border.LineWeight = ExcelChartLineWeight.Hairline;
chart.PrimaryCategoryAxis.CategoryType = ExcelCategoryType.Category;

chart.AutoScaling = false;

chart.PrimaryCategoryAxis.Offset = 1;
chart.PrimarySerieAxis.ReversePlotOrder = true;


chart.Floor.LineProperties.LineWeight = ExcelChartLineWeight.Hairline;
chart.Floor.LineProperties.LineColor = Color.Yellow;
chart.PrimaryCategoryAxis.HasMajorGridLines = true;

chart.PrimaryCategoryAxis.MajorGridLines.Border.LineColor = Color.Blue;
chart.PrimaryCategoryAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

chart.PrimaryValueAxis.HasMajorGridLines = true;
chart.PrimaryValueAxis.MajorGridLines.Border.LineColor = Color.Red;
chart.PrimaryValueAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

chart.PrimarySerieAxis.HasMajorGridLines = true;
chart.PrimarySerieAxis.MajorGridLines.Border.LineColor = Color.Yellow;
chart.PrimarySerieAxis.MajorGridLines.Border.LineWeight = ExcelChartLineWeight.Hairline;

I have attached a Image with the result of this code.

Thanks,
Andrei



09-Nov-2010 1-48-06 PM_c3d8a6fe.zip

[Sathish Babu R]

Hi Andrei,

Thank you for your interest in Syncfusion products.

We are not able to reproduce the mentioned issue “not supported by this chart type” exception at our side. We have created the sample and tested with assembly version 8.2.0.18 (3.5 .Net framework). But upon further investigation we found that XlsIO generated output chart format is not preserved properly and this issue has been fixed in our latest version. So, we request you to upgrade your current Essential studio version to 8.4.0.10. Please try the attached sample with the latest assembly version and let us know if this helps you.


Sample:
http://help.syncfusion.com/samples/xlsio.windows/F94004.zip

Please let us know if you have any queries.

Regards,
Sathish

[andrei gafton]

Thanks, this was the solution.

[andrei gafton]

Thanks, this was the solution. Using ChartArea instead of Column_3D chartarea.

[Lokesh R]

Hi Andrei,

We regret for the inconvenience caused.

As we have updated earlier, Can you please upgrade your essential studio version to 8.4.0.10 and try the below sample.

sample link:
http://help.syncfusion.com/samples/xlsio.windows/F94004.zip

Please let us know if you need any clarifications.

Thanks,
Lokesh.