Pie Chart - legend missing one category (edited to include spreadsheet)
I have set of pie charts and when I add data to some of them, there is one category name that is missing in the legend (it is also missing in the "Horizontal (category) Axis Labels," see below) even though I have selected it a million times! The data for this category does show up in the pie chart and the color for the category also shows up in the legend (see below). I tried putting the category name on the data label to see if it would show up, and it did not show up there either. I've also tried making the category name short, removing the legend & adding it back, and making the legend larger. None of these fixed it. I also deleted all the category labels, selected all new ones, and all 3 did show up. When I selected the real ones again, that one does not show up. This is driving me crazy. Please help. thanks!
