Hi,
Seeking a solution to change the chart bar/column widths using VBA, and not using gap width/series overlap operators (as these are dependent on other chart variables).
Need to create consistent chart bar and column widths, for a consistent look and feel across a document. Normally graphic design would do this bit, but we don't have one
Not found anything specific anywhere after much searching, although believe the operator that might do it is .BarWidth (but haven't seen an example of its use to know how to call it up etc)
Thanks!
Seeking a solution to change the chart bar/column widths using VBA, and not using gap width/series overlap operators (as these are dependent on other chart variables).
Need to create consistent chart bar and column widths, for a consistent look and feel across a document. Normally graphic design would do this bit, but we don't have one
Not found anything specific anywhere after much searching, although believe the operator that might do it is .BarWidth (but haven't seen an example of its use to know how to call it up etc)
Thanks!