Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a way to remove the default parentheses in a block chart?
Thanks!
If my understanding is correct, you have created an Block Chart visualization and you have enabled the Show Numbers with Labels option under Presentation tab. Then you want to remove the parenthesis that are displayed by default next to the label with the numeric value. I believe, this is not possible, as there is no option in the Chart Properties that would support this functionality. The parenthesis are included by default to distinguish the label from the number, so this is working as designed and thus if you want more control over how the value is displayed, then I would suggested creating a feature request [1].
---
If you have opened multiple workbooks, and need to remove all the text within parentheses in the opened workbooks, you can use Kutools for Excel’s advanced Find and Replace to find and replace text across workbooks.
If my understanding is correct, you have created an Block Chart visualization and you have enabled the Show Numbers with Labels option under Presentation tab. Then you want to remove the parenthesis that are displayed by default next to the label with the numeric value. I believe, this is not possible, as there is no option in the Chart Properties that would support this functionality. The parenthesis are included by default to distinguish the label from the number, so this is working as designed and thus if you want more control over how the value is displayed, then I would suggested creating a feature request [1].
---
If you have opened multiple workbooks, and need to remove all the text within parentheses in the opened workbooks, you can use Kutools for Excel’s advanced Find and Replace to find and replace text across workbooks.