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?

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?