VBA code to invoke new Box & Whisker charts Excel 2016

[cliftonvilla]

I am trying to use the 'Record Macro' facility to include a simple Box & Whisker chart in a 64 bit implementation of Excel 2016. The macro completes after the necessary key strokes but appears not to produce any relevant code at all, is this a known bug? It works in 32 bit implementation but when transferring the 32 bit code to a 64 bit environment the VBA produces a basic graph as required but crashes when setting the title and design and it seems impossible to insert the code to adjust the title of the graph or its design dynamically. Any ideas?

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then comply with them. Thanks.