https://grandslambids.com/35-excel-chart-show-hidden-values/excel-chart-show-hidden-values-excel-vba-hide-series-chart-elements-in-excel-vba-part-2-2/