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.
by cuong on May 14, 2020
by cuong on May 08, 2020
by cuong on May 27, 2020
by Ingeborg Hawighorst on May 13, 2020
Posted in Microsoft Ignite The Tour 2019 on February 14, 2020