Built-in Axis Choices for the Horizontal Axis and Depth Axis in Excel 2007:-


Excel 2007 provides a few built-in options on the Layout ribbon for each axis. As mentioned previously, these options are a tiny fraction of the ones available. It is interesting to note that the options chosen for the built-in menus are a few of the obscure options that you may not have discovered before.

For the horizontal axis, the built-in menu choices allow you to specify that the data should be plotted left to right or right to left. The other choice is for the horizontal axis to appear without any tick marks or labeling. This choice seems remarkably similar to the choice None. Look into the Figure (given below).



(The choices in the Primary Horizontal Axis menu are interesting but obscure.)

This is one of the few built-in charting menus where you can choose one item and then alter that selection by choosing another menu item. If you choose Show Right-to-Left Axis and then Show Axis without Labeling, you get a right-to-left axis without labeling. If you reverse those choices, however, the axis labels reappear.

The choices for the depth axis in a surface chart are similar to those for the horizontal axis. Instead of calling the choices Left-to-Right and Right-to-Left, however, the depth axis menu offers the options Normal Axis and Reverse Axis.