Forum Discussion
Pie Chart - legend missing one category (edited to include spreadsheet)
- 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.
Thank you. I am selecting the cell. My data and their related categories are all over the worksheet, so I used CTRL and pick each one separately. My other pie charts are working fine, as far as this issue goes, other than one that has the same issue. I will probably just need to delete those two and start over. I had started from one chart initially, got it the size I wanted, etc., and then copied it a bunch of times.
Okay. Upload your chart if you can't get it to work. Than I (or someone else) can hav a look at it.
Unfortnately my workbook has all sorts of patient data in it so I can't upload it. I'll see if I have time to make a copy of just the data, without the related formulas, to upload.
