Change the Minimum Bounds of the vertical axis to 120,000 and let the Maximum Bounds change automatically to 210,000. Change the Number format of the vertical axis to Currency
Help me to solve it pls.
- Change the Minimum Bounds of the vertical axis to 120,000 and let the Maximum Bounds change automatically to 210,000.
- Change the Number format of the vertical axis to Currency with 0 decimal places and $ as the symbol.
- Change the Minimum Bounds of the horizontal axis to 1,500 and let the Maximum Bounds change automatically to 2,500.
krishna asked 2 years ago
Double click on the chart and the new section titled Format Chart Area will appear on the right hand side.
Click on the Axis Options dropdown and select 'Vertical (Value) Axis' option.
After that, select the 'Axis Options' icon, which is the last icon.
Under the Bounds section, change the Minimum bounds to 120,000 and Maximum bounds will hange automatically to 210,000.
After that, click on the Number dropdown (it must be at the bottom side). Under the Category section, click the dropdown and select Currency. Leave the decimal places as 0 and $ as the symbol.
Switch to the 'Horizontal (Value) Axis' from the 'Vertical (Value) Axis'. Under Axis options, change Minimum Bounds of the horizontal axis to 1,500 then the Maximum Bounds will changes automatically to 2,500.