How to change 2d contour color fill or palette in XlsIO

Last post 03-16-2011, 2:54 AM by Amjad Sahi. 1 replies.
Sort Posts: Previous Next
  •  03-15-2011, 7:12 AM 290821

    How to change 2d contour color fill or palette in XlsIO .NET

    Attachment: Present (inaccessible)

    hi,

    This is original sample is attached here.

    help me to come out the solution..

    I prepared an example for you (attached). The “Temperature, Field_data” is the data sheet. The “Temperature, Field” is generated by Aspose (with ExcelChartType.Surface_Contour). The result_from_MSExcel_surface_con is generated in MSExcel as down with selecting all the data, Insert-Surface-Surface Contour. What we can do to make “Temperature, Field” like The result_from_MSExcel_surface_con? 

     One of my questions is how to increase the number of legends of the surface contour. If we look at the legend of the example, it has 0-10, 10-20, 20-30 and 30-40. How can we link the 4 categories with the chart series in the example as you mentioned in your last post? I am thinking it would be great to increase the number of legends (say 0-5, 5-10 and ….35-40)?

     Except for the question of how to create Creating 2D contour color palette, can we also assign colors to each legend such as 0-10 uses the red color and 10-20 uses the green color and so on?

     Thanks,

     
  •  03-16-2011, 2:54 AM 290997 in reply to 290821

    Re: How to change 2d contour color fill or palette in XlsIO

    Hi,

    Thanks for providing us the template Excel file containing your desired chart.

    I am afraid, currently, Aspose.Cells component does not support to apply/change Excel 2007 built-in Chart Styles to Surface chart, so you cannot create exactly the same chart at the moment. Also, for your second part, we do not support it too.

    We have logged your feature request into our issue tracking with an id: CELLSNET-25239. We will look into to support it soon.

    Once we have any update, we will let you know about it.

    Thank you.

    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     
View as RSS news feed in XML