Formatting ALL data labels for ALL data series at once

[Vasco]

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 ?

 

[Jon Peltier]

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]

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

 

[Vasco]

Thanks.

I only coded the macro because i couldn't find a way through the UI.
It unfortunate that the UI does not have a way to do this...

Thanks
Vasco

 

[Shane Devenshire]

Hi Vasco,

You don't have a UI method to change all the alignments and type of info
displayed with one command, but in 2007 the Format Data Labels dialog box is
Modal, which mean you can leave it open and click on each of the sets of
data labels one at a time, make your changes and go to the next set without
closing the dialog box.

Cheers,
Shane

 

[Meenie]

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]

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

- Jon