The drop-down contains the commands: Primary Horizontal Axis, Primary Vertical Axis, None, Show Left to Right Axis, Show Axis without Labeling, Show Right to Left Axis, Show Default Axis, Show Axis in Thousands, Show Axis in Millions, Show Axis in Billiions, Show Axis with Log Scale, More Primary Axis Options.

The drop-down contains the commands: None, SHow Data Table, SHow Data Table with Legend Keys and More Data Table Options.Īxes - (Moved in 2013). The drop-down contains the commands: None, Center, Inside End, Inside Base, Outside End and More Data Label Options.ĭata Table - (Moved in 2013). The drop-down contains the commands: None, Show Legend at Right, Show Legend at Top, Show Legend at Left, Show Legend at Bottom, Overlay Legend at Right, Overlay Legend at Left, More Legend Options.ĭata Labels - (Moved in 2013). If you have an axis title selected you can click on either Horizontal or Vertical Axis Title Options. The drop-down contains the commands: Primary Horizontal Axis Title, Primary Vertical Axes Title, None, Title Below Axis, Rotated Title, Vertical Title, Horizontal Axis and More Primary Axis Title Options. The drop-down contains the commands: None, Centered Overlay Title, Above Chart and More Title Options.Īxis Titles - (Moved in 2013). In 2013 all these commands can be found on the 'Add Chart Element' drop-down on the Design Tab.Ĭhart Title - (Moved in 2013). Toggles the insertion of a textbox into the chart area. Exactly the same command can be found on the Insert tab. Displays the 'Insert Picture' dialog box. In 2013 this group was moved to the Format tab and called 'Insert Shapes'. Clears any custom formatting from the selected element to ensure that the formatting matches the overall theme of the workbook. Displays the Format dialog box for the item that is currently selected in the 'Chart Elements' drop-down. In 2003 Category Gridlines are selected but in 2007 Category Gridlines is not selected.įormat Selection - (Moved in 2013). Choosing a particular item will select the corresponding item on the active chart. The drop-down contains a list of all the individual items that make up the chart that is currently selected. In fact this group was duplicated in 20.Ĭhart Elements - (Moved in 2013). In 2013 this group was moved to the Format Tab. In 2013 this tab was removed and replaced with a new 'Chart Layouts' group that was added to the Design Tab.

Design tab in excel for mac