How do I re-position chart data labels?

  • Thread starter Thread starter Alistair Shutt
  • Start date Start date
A

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.
 
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
 
Hi Alistair,

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

Alistair said:
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.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top