Hi,

Then use the Stacked version of the chart, which will center the labels
automatically.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"DianeG" wrote in message
...
Thanks Andy

I wanted them on a 3d bar the centre of the bar, i can only move them
there
individually

diane

"Andy Pope" wrote:

Hi,

With 3d column chart the data labels only have the position of outside
end.
3d stacked column has Center.

Where did you want the labels?

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"DianeG" wrote in message
...
Hi

is there an easy way to move data labels on a 3d chart. Currently I'm
moving them individually. Can it be done all at once. i've found out
how
to
do it on 2d but the label position isn't available on a 3d chart.

Thanks

Diane