ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Issues when pivot charts are refreshed and pivots has filters (https://www.excelbanter.com/charts-charting-excel/252265-issues-when-pivot-charts-refreshed-pivots-has-filters.html)

Saswato Mitra

Issues when pivot charts are refreshed and pivots has filters
 
Dear Sir,

Need help with pivot charts. The problem I am facing is as given.

Have created a pivot. It has filters, by name and we want to track for each
person productive & non productive hours. One name is chosen and a pie chart
is made and formating done with labels (to display the absolute no. and %).

Post this when another person is chosen in the pivot with the filter the
complete formating goes for a toss. No labels can be seen. What is the way
out?

Wish you Happy New Year 2010

regards
saswato mitra


Herbert Seidenberg

Issues when pivot charts are refreshed and pivots has filters
 
Excel 2007 PivotTable, PivotChart
Seems to work in my setup:
http://c0444202.cdn.cloudfiles.racks.../01_03_10.xlsx


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com