Hi, all:
My boss has requested a visual chart of everyone's total compensation (so their salary, plus any bonuses/contributions from the company, including the portion of healthcare premiums we pay). I have an Excel sheet with everyone's name, annual salary, and separate columns for any further contributions we make. I'm trying to create a pie chart that shows the grand total, but I'm also trying to figure out how to do this for each individual employee. Is there a way to create the chart and have the numbers update based on whose information is highlighted?
Sorry if this doesn't make sense - I use Excel quite a bit for reporting, but it's been a long time since I've used it to create graphs. For some reason, the information I put into the table also comes up on the pie chart incorrectly, so I'm trying to figure out how to rearrange it.
Thanks in advance!
