Ah yes. Excel 2007 has lost a lot of the familiar old dialogs. Since you're
using code in your post, here is what the macro recorder provides in 2003,
and it works in 2007:
ActiveChart.ApplyDataLabels AutoText:=True, LegendKey:=False, _
HasLeaderLines:=False, ShowSeriesName:=True,
ShowCategoryName:=False, _
ShowValue:=False, ShowPercentage:=False, ShowBubbleSize:=False
However, since you're using code, looping through all series in a chart
shouldn't be as painful as manually formatting each series.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Vasco" wrote in message
...
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 ?