To modify the y-axis format to include percentage changes, follow these steps:
- Right-click on the y-axis of the chart.
- Select "Format Axis" from the context menu.
- In the "Format Axis" pane, go to the "Number" section.
- Select "Percentage" from the "Category" list.
- In the "Decimal places" field, set the number of decimal places you want to display.
- In the "Symbol" field, select "None" to remove the percentage symbol.
- Check the box next to "Axis value" under the "Display units" section.
- In the "Display units" field, select "Hundreds" or "Thousands" depending on your preference.
- Click "Close" to apply the changes.
Now, the y-axis will display percentage changes in the format you have selected.