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.