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

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

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

The inflexibility of 3D charts is a good reason not to use 3D charts. More
important reasons include the distortion of the data caused by the oblique
perspective.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"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

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