how do i edit the horizontal axis in excel for mac 2016

To replace these generic titles with the actual chart titles, click the title in the chart or click the name of the title on the Chart Elements drop-down list.

Its text box displays the name of the element currently selected in the chart.) Excel lets you know that a particular chart title is selected by placing selection handles around its perimeter.

To force part of the title onto a new line, click the insertion point at the place in the text where the line break is to occur.

To change the font used in a title or any of its attributes, select the title and then use the appropriate command buttons in the mini-toolbar that appears next to the selected title or from the Font group on the Home tab.

Simply click the Font or Font Size drop-down buttons and then highlight different font names or sizes to have the selected chart title appear in them.

To format the entire text box that contains the title, click one of the following buttons in the Shape Styles group.

You can display units on the axis (hundreds, thousands, 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 (y-axis when modifying the x-axis and x-axis when modifying the y-axis) crosses.

To assign the same number formatting to the values on the selected axis as assigned to the values in their worksheet cells, simply select the Linked To Source check box.

Then, 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.

However, these changes are set in the chart only when you click Close in the Format Axis dialog box.

Greg wrote his first computer book more than twenty years ago and since that time, he has amassed a long list of bestselling titles including Excel All-In-One For Dummies (all editions) and Excel Workbook For Dummies (all editions).

How Do I Edit The Horizontal Axis In Excel For Mac 2016