Vary colors by point

Aspose.Cells Product Family
1

Hi,


I am building a chart in excel and I would like to have the bar colours automatically varied. I have seen a option in excel called Vary colors by point in Format Data series menu under fill. Is this option available programatically? How can I achieve this?

Kind Regards,

Shruti
2

Hi,


Please try:
chart.getNSeries().setColorVaried(true);




Thank you.
3

Thanks for your quick reply. That worked!

4

Hi,


Good to know that it works for you. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.