Share via

Remove legend key from chart

Anonymous
2019-04-25T03:11:24+00:00

Hi everyone,

I have a legend on a bar chart that I have created in excel. It has the usual legend key and the text next to the key. Is it possible to remove the legend key (ie. the little square to the left of the text) and just keep the text in the legend?

Would be grateful for any advice.

Thanks in advance.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.8K Reputation points Volunteer Moderator
2019-04-25T03:29:55+00:00

Hi gwnh

Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

Unfortunately, the answer is No. Both the square and text are joined and can be added or removed together,

There is a work around to give the result which you want.

  • Delete the legends completely
  • Insert a text box there and write the text required

Do let me know if you require any further help on this. Will be glad to help you.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-04-26T05:52:40+00:00

    Thanks for letting me know - much appreciated

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments