I have a very busy stacked bar chart, some 20 or so series over time
I am not interested in the actual numbers, I just want to show the overall trend over time.
The default colours in Excel 2010 are so similar that it makes it almost impossible to pick out the individual series
The only option appears to be to add 'data labels' i.e. the underlying numerical values - this is not what I want
I want to show the series name (a short 3 digit code) which should easily fit inside (or next to) a section of a stacked bar
This also means I will then be able to remove the legend, freeing up more space for the plot area