Pivot Chart Data labels   

Using Excel 2003. In a pivot table line chart, if you use the option to 
display values on the data set line in the chart, the values disappear when 
you drill down into the data.  So for example, if the data represents sales 
for a number of locations, when you use the pull down to pick a specific 
location, the data labels disappear. How can you maintain the option to 
display labels with each drill down?

date: Mon, 25 Aug 2008 09:04:02 -0700   author:   DaveK

RE: Pivot Chart Data labels   

Hi,

This is one of the many things that are lost on refresh IF you add the data 
lables to a series.  To beat this problem you can 1. Add the data labels via 
the Chart, Chart Options dialog box. or 2. Write VBA code.  The downside of 
the first is data labels appear on all points, the downside to the second is 
you need to know VBA.
-- 
Cheers,
Shane Devenshire


"DaveK" wrote:

> Using Excel 2003. In a pivot table line chart, if you use the option to 
> display values on the data set line in the chart, the values disappear when 
> you drill down into the data.  So for example, if the data represents sales 
> for a number of locations, when you use the pull down to pick a specific 
> location, the data labels disappear. How can you maintain the option to 
> display labels with each drill down?

date: Tue, 26 Aug 2008 12:00:07 -0700   author:   ShaneDevenshire