Forum Discussion
Question: labels in an Excel doughnut chart
- Nov 15, 2020
Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Rename legend entries
The legend can be renamed in Excel in a few steps.
To do this, proceed as follows. Open your Excel document and click on your chart.
In the upper bar you will find the "Diagram Tools".
Click on the "Design" tab.
In the "Data" group, click the "Select Data" button.
In the left window you will find the legend entries.
Click on an entry and select "Edit".
You can now rename the entry under "Row name".
Excel: Rename entries
Change the horizontal axis label
If your values are not displayed as legend entries but as horizontal axis labels, you have to proceed differently.
Open your Excel document and click on your chart.
In the upper bar you will find the "Diagram Tools".
Click on the "Design" tab. In the "Data" group, click the "Select data" button.
In the right window you will find the "Horizontal axis label".
Click on "Edit". Now enter your desired names or values for the legend.
Separate multiple entries with a semicolon.
Finally, click OK".
Rename a data series
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
Knowledge of Excel version and the operating system is a must have if you want to proposing a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Rename legend entries
The legend can be renamed in Excel in a few steps.
To do this, proceed as follows. Open your Excel document and click on your chart.
In the upper bar you will find the "Diagram Tools".
Click on the "Design" tab.
In the "Data" group, click the "Select Data" button.
In the left window you will find the legend entries.
Click on an entry and select "Edit".
You can now rename the entry under "Row name".
Excel: Rename entries
Change the horizontal axis label
If your values are not displayed as legend entries but as horizontal axis labels, you have to proceed differently.
Open your Excel document and click on your chart.
In the upper bar you will find the "Diagram Tools".
Click on the "Design" tab. In the "Data" group, click the "Select data" button.
In the right window you will find the "Horizontal axis label".
Click on "Edit". Now enter your desired names or values for the legend.
Separate multiple entries with a semicolon.
Finally, click OK".
Rename a data series
Hope I was able to help you.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here
NikolinoDE Thank you! This is perfect.
On a related note, do you know if it is possible to snap the data label of each segment to the segment itself, so that the text follows the shape of the doughnut? I know you can change the angle of the data labels, but this is slightly different.
- NikolinoDENov 16, 2020Gold ContributorThis information should be able to help you.
Edit titles or data labels in a chart
https://support.microsoft.com/en-us/office/edit-titles-or-data-labels-in-a-chart-248bfe15-02ed-477a-81b6-b14e2c03b87e?ui=en-us&rs=en-us&ad=us
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)