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

Aspose.Cells Product Family
1

Hi,

This is the original sample attached here.

Help me to find a 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 shown when selecting all the data, Insert-Surface-Surface Contour. What can we 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 a 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,

2

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.