How do I re-position chart data labels?

[Alistair Shutt]

When creating a 3-D Clustered Bar Chart using the wizard,
data labels are positioned at the end of the bars. The 3-D
bar shadow makes it difficult to see any values.

Rather than doing so manually, is there a quicker way to
re-position all data labels to the centre of their bars?

PS. A workaround for this problem when using only one
series is to select 'Stacked Bar', but this is of no use
with >1 series.

Thanks.

 

[Jon Peltier]

Alistair -

Suggestion #1: Use 2D charts. The 3D effects can distort the reader's
interpretation of the data, beyond your problem with the label
positions. You didn't say "MBA" after your name, so I doubt that's your
intent. (Just kidding!)

Suggestion #2: Rob Bovey's Chart Labeler (a free addin at
http://appspro.com) not only lets you apply custom data labels, it
allows you to move one or many of them precisely and easily, without
mousing around.

- Jon

 

[Andy Pope]

Hi Alistair,

This may help.
(http://www.andypope.info/ngs/ng19.htm)

When creating a 3-D Clustered Bar Chart using the wizard,
data labels are positioned at the end of the bars. The 3-D
bar shadow makes it difficult to see any values.

Rather than doing so manually, is there a quicker way to
re-position all data labels to the centre of their bars?

PS. A workaround for this problem when using only one
series is to select 'Stacked Bar', but this is of no use
with >1 series.

Thanks.

--

Cheers
Andy

http://www.andypope.info