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
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.