Disappeariong Labels in Pivot Charts

[Garyrrapp]

I am using Excel 2002 in XP Professional and I have several pivot charts set up with data labels. Whenever I change the parameters of the pivot chart, I lose the labels. What gives? Is there a set up command I should check to keep the lables on there? I am using the labels to post the values on the bar chart. Thanks.
Gary

 

[Chris (UK)]

Gary,

I've just found the same problem, extremely annoying. I've got a rather crude solution, but it appears to work.

I recorded the code for putting the labels back on and put against the Chart's calculate event, thus:

Private Sub Chart_Calculate()

ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).ApplyDataLabels AutoText:=True, LegendKey:= _
False, ShowSeriesName:=False, ShowCategoryName:=False, ShowValue:=True, _
ShowPercentage:=False, ShowBubbleSize:=False
ActiveChart.ChartArea.Select
End Sub

Finally I didn't put the code in a normal module but behind the actual chart in question.

The last line just unselects the series so it looks slightly less naff.

If you are selecting the changes in the pivot table and then going to the chart, I suggest using the chart's Activate event instead.

There must be a more elegant solution. Anyone?

By the way thanks to everyone for the great stuff on this board - up to now I've found everything on a search.

Chris

 

[Tiborakos]

Hello,

i have the same problem with the labels and it also comes to the Label Formating (Title and % in a pie chart) and position (so as for Labels not to overlap). First action was to record a Macro that would put everything back in place, however that might lead to mistakes when data change significantly...
So i am desperate for any help, appreciate it...

Regards

George

PS. i was reasy to submit a post when i realized that my problem was others problem....thanks