07-30-2019 12:48 PM
@cuongnice post, I am looking forward to the new features of Excel!
Can you please direct me to the reference page for the Excel 2016 Sunburst Chart's objects? I need to set the interior color of each data point in the chart with VBA. Thanks so much!
07-31-2019 09:14 AM
@djpeterso23662 @cuong You can look at the VBA Developers Reference for starters. Regarding setting interior colors, see: https://www.thespreadsheetguru.com/blog/2015/3/1/the-vba-coding-guide-for-excel-charts-graph.
For me, the best way to expose objects and methods is to record a macro applying the changes you want. The recorder will capture it, then you can put that in your working code.