View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
DaveK DaveK is offline
external usenet poster
 
Posts: 14
Default 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?