Home > database >  How do I make my Data Labels in my Excel chart have a square next to it that are the same are the on
How do I make my Data Labels in my Excel chart have a square next to it that are the same are the on

Time:10-16

I have a Pie chart and since there are many data I want to show values and % in the Data Labels. Those two are quite simple but I want to add the square next to the data labels that is the same as the one that appears in the Legends so it is easier to know what you are looking for.

CodePudding user response:

Right click on the data label, select "Format Data Labels..." and under "Label Options" check the "Legend Key" checkbox.

This will add the little square as it appears on the legend.

  • Related