Tuesday, October 16, 2012

How to Format the Values of Vertical Axis Currency in Excel


1. Click and drag to select the cells for the vertical axis. To select the entire row or column, click the cell header.
2. Click the 'Home' tab on the command ribbon.
3. Click the down-arrow for the 'Accounting Number Format' button in the 'Number' group. This button displays a currency symbol. A list of currencies and symbols appears.
4. Click the currency, such as U.S. dollar or the Euro.
5. Click the arrow in the bottom-right corner of the 'Number' group. A window entitled 'Format Cells' opens.
6. Click the 'Number' tab.
7. Click the 'Currency' option. The selected currency appears in the 'Symbol' and 'Negative Numbers' text box.
8. Select the number of decimal places in the 'Decimal places' text box. For example, '2' for U.S. dollars.
9. Click an option in the 'Negative numbers' text box. For example, a negative number can appear in red text or inside parenthesis.
10. Click 'OK.'
11. Type the values for the vertical axis. The values automatically format to the selected currency.

Blogger news