If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pie PivotChart loses data label every time i swich page value
I have 4 columns
1. Month 2. Item 3. Category 4. Amount I have created a pivot table and pivot chart the following way: For the PivotTable Wizard: I have put Month at the page level. I have put Category on the Row level I have put Sum of Amount on the Data Section. Now I create a pivotchart as a pie chart based on this pivottable. If I select all of the data labels to show the percentages and amounts in the PieChart, that works fine. The issue is if i go to the Month dropdown (the page level column in the PivotTable) and generate a new pie chart for a new month, it loses the fact that i want to display of the piechart data labels. I have to go back to "Format Data Series" and go to "Data Labels" and recheck all of the labels that i want to see.. Is there anywhere to persist the fact that i want to show labels always in the piechart so i dont have to recheck this ever time i change the page to a new month. thks, ak |
#2
|
|||
|
|||
Pie PivotChart loses data label every time i swich page value
You'll have to create a macro to format it the way you want. WHen you
update the pivot, run the macro. wrote in message ups.com... I have 4 columns 1. Month 2. Item 3. Category 4. Amount I have created a pivot table and pivot chart the following way: For the PivotTable Wizard: I have put Month at the page level. I have put Category on the Row level I have put Sum of Amount on the Data Section. Now I create a pivotchart as a pie chart based on this pivottable. If I select all of the data labels to show the percentages and amounts in the PieChart, that works fine. The issue is if i go to the Month dropdown (the page level column in the PivotTable) and generate a new pie chart for a new month, it loses the fact that i want to display of the piechart data labels. I have to go back to "Format Data Series" and go to "Data Labels" and recheck all of the labels that i want to see.. Is there anywhere to persist the fact that i want to show labels always in the piechart so i dont have to recheck this ever time i change the page to a new month. thks, ak |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |
Use first record found in expression? | CASJAS | Running & Setting Up Queries | 17 | July 22nd, 2004 09:21 PM |