A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pie PivotChart loses data label every time i swich page value



 
 
Thread Tools Display Modes
  #1  
Old February 19th, 2006, 04:47 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Ads
  #2  
Old February 19th, 2006, 07:51 PM posted to microsoft.public.excel.charting
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 07: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 03:54 PM
Use first record found in expression? CASJAS Running & Setting Up Queries 17 July 22nd, 2004 09:21 PM


All times are GMT +1. The time now is 06:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 OfficeFrustration.
The comments are property of their posters.