Hi, I would like to know how to set the minimum column width for a dynamic number of categories for a stacked bar chart.
The problem is that when the chart is resized below a certain height then the category axis labels become bunched together and the bar widths become smaller than the series label text therefore the text no longer fit inside the bars, see attached image.
The chart is resized via the splitter.
Setting the gap and spacing properties only seems to work if you have a chart with a fixed amount columns, not columns that could be from 0 - n.
Effectively the minimum bar width should not be less than the size of the font used for the series labels.
I have tried preventing the chart from further reducing in height base on current height / number of columns, but this solution is glitchy depending on how much or how quick the splitter is moved.
How else can I set the minimum bar widths or reliably prevent the chart from resizing based on the current chart dimension and number of columns?
Andy
The problem is that when the chart is resized below a certain height then the category axis labels become bunched together and the bar widths become smaller than the series label text therefore the text no longer fit inside the bars, see attached image.
The chart is resized via the splitter.
Setting the gap and spacing properties only seems to work if you have a chart with a fixed amount columns, not columns that could be from 0 - n.
Effectively the minimum bar width should not be less than the size of the font used for the series labels.
I have tried preventing the chart from further reducing in height base on current height / number of columns, but this solution is glitchy depending on how much or how quick the splitter is moved.
How else can I set the minimum bar widths or reliably prevent the chart from resizing based on the current chart dimension and number of columns?
Andy