View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.charting
Meenie Meenie is offline
external usenet poster
 
Posts: 192
Default Formatting ALL data labels for ALL data series at once

this works to add the series name but not the alignnment. Is t here a way to
change to alighment to all of them too? (I have excel 2003)
thanks!

"Jon Peltier" wrote:

You can pick Show Series for all series of labels at once, if you select the
chart, go to the Chart menu Chart Options Data Labels tab. This does all
series at once, not just the ones you've already labeled.

You cannot apply other formatting to more than one series of labels at a
time.

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


"Vasco" wrote in message
...
I've applied data labels to a pivot chart (PivotChar Tools/Layout/Data
Labels/Inside End).

Then, i actually want the data series name to show instead of the value
and
also want the text orientation to be vertical.

I can change this for a single data series, but not for all at once.

Am i missing something ?