I'm generating a stacked column chart out of an a table like this:Year 1 23A5000B5000C0 1000D0 50 0E0 0 10F0 0 15I want column stacks for every year, with series labels for every non-zero value. Currently if I try and add labels then I get 6 labels for every series (with the zero values clustered around the axis). How do I generate series labels for all non-zeroes? I am happy to rearrange my data to a different format to the table above. I am using Excel 2013.
that works well for me