In the Bar chart, replace the number format for values on the Vertical Axis with the yyyy custom format code. In excel

Answer 1

To change the number format for values on the Vertical Axis in a Bar chart to the yyyy custom format code in Excel, you can follow these steps:

1. Click on the Vertical Axis of the Bar chart to select it.
2. Right-click on the selected Vertical Axis and choose "Format Axis" from the context menu.
3. In the Format Axis pane that appears on the right side of the screen, go to the "Number" tab.
4. In the Category section, select "Custom" from the list.
5. In the Type field, enter the custom format code "yyyy".
6. Click on the "Add" button if needed and then click "Close" to apply the changes.

This will change the number format for values on the Vertical Axis to display only the year (yyyy) in the Bar chart.