3D Stacked Column Chart - Data labels positioned above each column rather than mid-column (XL2007)

[AOB]

Hi all,

Hoping this is straightforward...

I have a fairly basic 3D column chart with data labels for each column. Unfortunately, some of the column values are quite small (~0 in comparison to others which are ~3,000) which means the labels for these columns look a bit cumbersome when they are positioned 'mid-column'.

I'd prefer to position the data labels above (or 'outside-end') the columns to rectify this, but when I try to format the data labels to do so, no option is available?

I can physically select each label and move it manually but I have 20-odd columns per chart and about a dozen charts. Is it not possible to have outside-end data labels on a 3D column chart??

Thanks

AOB

 

[AOB]

FYI for anyone with the same problem...

By changing the chart type from a 3D Stacked Column (i.e. each series stacked 'one-on-top-of-the-other' in a single column) to a 3D Column (i.e. each series gets its own stack in a separate row on the 'Z' axis), the data labels magically moved from mid-column to above each column.

So if you only have one series but you want the labels to be above rather than inside, switch the chart type (the charts themselves will appear basically the same)