Thanks Jon.

I forgot to mention i'm using XL 2007.
I don't see a chart menu / options. How can i bring that up?

On any case, i built a macro to do what i wanted.
Sub FormatChartDataLabel()
ActiveSheet.ChartObjects("Chart 1").Activate

Dim ch As Chart
Set ch = ActiveChart

Dim sc As SeriesCollection
Set sc = ch.SeriesCollection

Dim s As Series
For Each s In sc
Set dl = s.DataLabels
dl.ShowSeriesName = True
dl.ShowValue = False
dl.Orientation = -4171
Next
End Sub



"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 ?