Share via

Resizing the chart add data label

Anonymous
2018-06-06T14:44:39+00:00

I am building a Box and Whisker chart. I had to manually deleted the data labels from all data points besides the outliers (could not find an option to add data labels to ONLY outliers). After I did it, I had to resize the chart to make it smaller. But when I did so, the data labels were added back. When I stretch the chart, they sometimes disappear, sometimes don't. I am confused. Is there an option to opt off? 

Thank you.

Microsoft 365 and Office | Excel | For home | Windows

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 No comments

Answer accepted by question author

Anonymous
2018-06-06T18:41:26+00:00

Hi Iriskasun,

Thanks for your sharing and we are glad to help you.

Based on my test, the data labels will not come back after I resize the cart.

To delete data labels normally, I'd like to suggest you check this article: Add or remove data labels in a chart to do that. Please have a try and share with me your result.

Besides, please also share with me more info as below to let me have a better understanding of your scenario:

  1. The detailed version number of your OS(Win+R>type CMD>OK) and Office(File>Account>Product Information).
  2. Steps about how you create your Box and Whisker chart and delete data labels.
  3. Does this issue happen to all files even newly created or only related ones?

Thanks,

Neo

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2018-06-09T03:20:39+00:00

    Hi Iriskasun,

    Have you checked the info above? Can you deleted data labels normally now? Does the deleted data lebels still back? Do you still need help? Please share with me your recent progress.

    Thanks,

    Neo

    Was this answer helpful?

    0 comments No comments