Forum Discussion
Solved
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 ...
- Excel is getting confused by your merged cells. If possible, unmerge the cells, and link the label to a single cell.
If you don't want to unmerge, then change the label refs in the series formula for the chart.
Click on the pie chart, and in the formula bar, change the merged cell refs to a single cell ref:
-- instead of: $O$21:$S$21 put $O$21
-- instead of: $O$20:$S$20 put $O$20
Managed to recreate your issue and suspect that you only copied the data into the graph but not the label. Please have a look at the attached screenshot. In the first graph I only added the yellow cell and created the issue that you describe. In the second graph I added the yellow cells and all looks how you want it to be.
Right click in the chart and press "Select data source". Make sure that the range for "Horizontal (category) axis labels" includes all the labels you want to be included.
PS: I'm working on a Mac, so your screens may look a bit different. But you should be able to find the horizontal axis settings as describe above.