We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Excel Chart : Floor property doesn''t work

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.

7 Replies

LR Lokesh R Syncfusion Team April 16, 2010 04:12 AM UTC

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


AG Andrei Gafton November 9, 2010 11:41 AM UTC

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;



AG Andrei Gafton November 9, 2010 11:52 AM UTC

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


SB Sathish Babu R Syncfusion Team November 10, 2010 01:05 PM UTC

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




AG andrei gafton November 10, 2010 03:56 PM UTC

Thanks, this was the solution.



AG andrei gafton November 10, 2010 07:19 PM UTC

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



LR Lokesh R Syncfusion Team November 11, 2010 10:34 AM UTC

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.


Loader.
Live Chat Icon For mobile
Up arrow icon