When I generate a chart the boxes are all there but they are completely blacked out. I suspect it’s something to do with the background colour but can’t find anywhere to set it to white.
Check these two Chart Settings under Appearance.
Box Border, Fill Color.
Colors, Chart Boxes - Default Boxes, Fill
Arghhhh! The fill colour was black. No wonder I was getting black boxes. Thank you.