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.