Hi,
Yes, as I said stagger your data and labels along with a dummy series.
Assuming your test data was in the range A1:E11 what you need to do is
insert a row between each data row, expanding it to A1:E20.
No insert a cell above the axis labels so they appear in A3:A21.
Add a set of data to column F with the label Dummy. The value being 100%
and populate the cells on the same rows as the axis labels.
In order to stop Excel incorrectly guessing your data add a space to the
currently empty cell A2.
Now select the range A1:F21 and create stacked bar chart.
Apply data labels to the Dummy series display category name.
Format the series to have no fill or border.
Delete the category axis.
You should now have double spaced stack bars with text in the middle,
but as I said that amount of text will not look pretty in a data label.
Cheers
Andy
Thank you Andy,
Well, using vba feels a little bit overkill for the users that wants this
behavior.
Is there any way to get the text above each bar even if it will be wrapped
or truncated?
Regards Magnus