Add VBA Support for Excel 2016 charts like Waterfall, Pareto etc
Please add VBA support for new Waterfall, Pareto, Histrogram, Treemap, Sunburst and Box & Wisker chart types. Specifically, include the ability to record a macro when operating on new charts and provide corresponding Excel VBA Object library nomenclature. There is currently no VBA support for new Excel 2016 chart types, making it impossible to automate and include them into existing toolsets. Waterfall chart support is a priority. Thanks!
Chris Newman commented
Currently trying to automate a waterfall chart for a client.....pulling my hair out trying to code the most simple of tasks! This is much needed!
I agree, this is very frustrating. I can't even change the font size of the x-axis (of a box and whisker) using vba. Thougt it would be easy. Ha!