Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Chart Axis Labels | Charts and Charting in Excel | |||
Chart - Data Labels | New Users to Excel | |||
Pie Chart Data Labels | Charts and Charting in Excel | |||
How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel | |||
Help with pivot charts and data labels | Charts and Charting in Excel |