Hi
Anne,
Yes, it is possible to remove the percent sign from the value axis of a 100% stacked bar chart without changing the values. Here are the steps to do it:
- Select the chart by clicking on it.
- Click on the "Format" tab in the ribbon.
- In the "Current Selection" group, click on the drop-down arrow and select "Vertical (Value) Axis".
- Right-click on the value axis and select "Format Axis" from the context menu.
- In the "Format Axis" pane that appears on the right side of the screen, go to the "Number" section.
- In the "Category" list, select "Custom".
- In the "Type" field, delete the percent sign ().
- Click on "Add" to add a new format code.
- In the "Type" field, enter the following code:
- Click "Close" to apply the changes.
This will remove the percent sign from the value axis while keeping the percentage values intact.