see attached pie chart. You can not reference the data points for a chart from individual range names. You need to have the values in cells and create your pie chart off those cells. Of course, you can show the pie chart labels as percentages.
As I said above, if you don't want the cells for the pie chart to show in this sheet, put them in another sheet.
Bookmarks