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.
Unfortunately, activation email could not send to your email. Please try again.

Excel Chart : Floor property doesn''t work

Thread ID:

Created:

Updated:

Platform:

Replies:

94004 Apr 15,2010 03:40 PM Nov 11,2010 05:34 AM ASP.NET Web Forms (Classic) 7
loading
Tags: XlsIO
Vinod K Bobba
Asked On April 15, 2010 03:40 PM

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 [Syncfusion]
Replied On April 16, 2010 12:12 AM

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
Replied On November 9, 2010 06:41 AM

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
Replied On November 9, 2010 06:52 AM

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 [Syncfusion]
Replied On November 10, 2010 08:05 AM

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
Replied On November 10, 2010 10:56 AM

Thanks, this was the solution.


andrei gafton
Replied On November 10, 2010 02:19 PM

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


Lokesh R [Syncfusion]
Replied On November 11, 2010 05:34 AM

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.


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;