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? |
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? |
All times are GMT +1. The time now is 06:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com