Free Support Forum - aspose.com

How to set color to Category Axis?

I have a bar chart and I want to be able to set color to the category axis but just for one bar. Is it possible to do this? How?


Excel

Hi,


How could you do this in MS Excel? Please create the chart with color set for the category axis specific label, attach the Excel file here. We will check how to do it in MS Excel.

Thank you

I just know that there’s this option in MS Excel to format Axis. I wanna know how to do this in Aspose Cells for Java and if it’s possible to format just one line (it should). Thanks.

Hi,


Thanks for the sample file.

I am afraid, to set background color of tick labels (feature) is not available at the moment. I have logged your feature request into our database with an id: CELLSJAVA-40009. We will support this feature soon.

Thank you.

Hi,


Please try the latest version/fix v7.0.2.4. This feature is supported now in this fix. Please use:
wb.Worksheets[0].Charts[0].CategoryAxis.Area.BackgroundColor = color --> to set background color of category Axis.

Thank you.