Disappeariong Labels in Pivot Charts

Garyrrapp

New Member
Joined
Feb 16, 2004
Messages
1
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Chris (UK)

New Member
Joined
Apr 21, 2004
Messages
1
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

New Member
Joined
Apr 29, 2004
Messages
4
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,163
Messages
5,768,555
Members
425,481
Latest member
ihumanl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top