Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
change the text in the legend of a chart w/o changing pivot text
I am trying to create a series of pie charts that compares demographic data
for clients assisted with multiple housing-related activities (new homebuyer, rehab, foreclosure prevention, etc.) If I want to look at the age of new homebuyers, on my pivot table I deselect all activities except new homebuyer. After I make my pie chart, in the legend the labels are "new homebuyer 18-24", "new homebuyer 25-34", etc. It's pretty self-explanatory that these are all "new homebuyers". I need for the New Homebuyer part to not be shown in the legend, but I can't change this in the source spreadsheet or pivot table because I need to continue using these to create more charts. I JUST WANT TO CLICK ON THE LEGEND AND BE ABLE TO MANUALLY EDIT THAT TEXT THAT IS IN THE LEGEND WITHOUT HAVING TO CHANGE THE SOURCE DATA. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
change the text in the legend of a chart w/o changing pivot text
I don't think its possible. I know you stated you didn't want to change your
source data, but would it be possible to have 2 columns, 1 of them being status (new homebuyer, foreclosed, etc.) and the other being age? Then you could make a graph with status being a page field, and age being the series. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "msp" wrote: I am trying to create a series of pie charts that compares demographic data for clients assisted with multiple housing-related activities (new homebuyer, rehab, foreclosure prevention, etc.) If I want to look at the age of new homebuyers, on my pivot table I deselect all activities except new homebuyer. After I make my pie chart, in the legend the labels are "new homebuyer 18-24", "new homebuyer 25-34", etc. It's pretty self-explanatory that these are all "new homebuyers". I need for the New Homebuyer part to not be shown in the legend, but I can't change this in the source spreadsheet or pivot table because I need to continue using these to create more charts. I JUST WANT TO CLICK ON THE LEGEND AND BE ABLE TO MANUALLY EDIT THAT TEXT THAT IS IN THE LEGEND WITHOUT HAVING TO CHANGE THE SOURCE DATA. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
change the text in the legend of a chart w/o changing pivot text
Depending on how much your chart data changes when you pivot the table, you
may be able to use a regular chart. This loses the pivoting but regains the flexibility of a regular chart. Here's a tutorial: peltiertech.com/WordPress/2008/06/13/regular-charts-from-pivot-tables/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "msp" wrote in message ... I am trying to create a series of pie charts that compares demographic data for clients assisted with multiple housing-related activities (new homebuyer, rehab, foreclosure prevention, etc.) If I want to look at the age of new homebuyers, on my pivot table I deselect all activities except new homebuyer. After I make my pie chart, in the legend the labels are "new homebuyer 18-24", "new homebuyer 25-34", etc. It's pretty self-explanatory that these are all "new homebuyers". I need for the New Homebuyer part to not be shown in the legend, but I can't change this in the source spreadsheet or pivot table because I need to continue using these to create more charts. I JUST WANT TO CLICK ON THE LEGEND AND BE ABLE TO MANUALLY EDIT THAT TEXT THAT IS IN THE LEGEND WITHOUT HAVING TO CHANGE THE SOURCE DATA. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing only Legend Text | Charts and Charting in Excel | |||
How do I put text in a chart legend box? | Charts and Charting in Excel | |||
changing cell text in a pivot table | Excel Discussion (Misc queries) | |||
How do I change formula results by changing the text color of the | Excel Discussion (Misc queries) | |||
Change a legend in Pivot Chart Report | Excel Discussion (Misc queries) |