Forum Discussion

Kim_C56's avatar
Kim_C56
Copper Contributor
Apr 26, 2021

I cannot change the default label positions on a pie chart. The option is not available

Under Add chart element/Data labels, I can only choose "none", "show" or "callout".  When I go to "More data label options", under "Format Data Labels" I can only choose "Label Contains" and "Number".  Position is not available anywhere.

Charting
excel
office 365

3 Replies

  • JonPeltier's avatar
    JonPeltier
    MVP
    May 04, 2021
    Pie charts should have several options: Center, Inside End, Outside End, and Best Fit.
    If you've actually made a Donut chart, there are no options, it just uses Center.
    • Kim_C56's avatar
      Kim_C56
      Copper Contributor
      May 04, 2021
      Thank you for your response. I've searched extensively for an answer to this problem and the only response seems to be that excel doesn't offer this option for all charts. So, I'll just have to untangle the labels each time I run the report.

      • JonPeltier's avatar
        JonPeltier
        MVP
        May 04, 2021
        Painful. I wonder if somehow the chart got messed up behind the scenes (corrupted). If you recreate the chart, do you get back all the options you expect?

Resources