Format Vertical Axis Excel How To Use IBM

Click the x -axis or y -axis directly in the chart or click the Chart Elements button (in the Current Selection group of the Format tab) and then click Horizontal (Category) Axis (for the x -axis) or Vertical (Value) Axis (for the y -axis) on its drop-down list.

Excel opens the Format Axis dialog box containing the following tabs: Axis Options, Number, Fill, Line Color, Line Style, Shadow, 3-D Format, and Alignment.

These options include those that fix the maximum and minimum amount for the first and last tick mark on the axis, display the values in reverse order (highest to lowest), apply a logarithmic scale, display units on the axis (hundreds, thousands, and millions, and so forth) and divide the values by those units, reposition the tick marks on the axis, and modify the value at which the other axis crosses.

For example, to select the Number format with the comma as the thousands separator and no decimal places, you select Number in the Category list box; then leave the Use 1000 Separator (,) check box selected and enter 0 in the Decimal Places text box.

Indicate the new orientation by clicking the desired vertical alignment in the Vertical Alignment drop-down list box and desired text direction in the Text Direction drop-down list.

These changes are, however, set in the chart only after you click Close in the Format Axis dialog box.

Format Vertical Axis Excel How To Use IBM

He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century.

After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.

His love of teaching has translated into an equal love of writing.

For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner.

They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.

Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May.

Format Vertical Axis Excel For Mac