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