Too easy to get correct.
I have two sets of data that I collect each month for 7 counties - dollar amount and households. I create a pie chart showing the dollar amount with the respective county but I would like the data label to not only show the county and dollar amount but also the household count and be updated automatically.
Here is what my simple spreadsheet looks like..
So far I have the county and dollar amounts but I need the household count within the label and that will update with changes. I do not, however, want the household count "part" of the pie chart.
Thanks in advance for any help on this.
Bookmarks