Show All

Add, remove, or change axes

1. In the design window, make sure the chart is activated. For instructions, see Help for your design program.
2. Do one or more of the following:

   Add an axis

   1. Click the chart workspace (the blank area between the plot area and the chart boundary).
   2. On the toolbar, click Commands and Options , and then click the Series Groups tab.
   3. Under Series groups, in the Select one or more series box, select the group of series for which you want to add an axis.
   4. If you want the axis to reflect a different series, you can group, ungroup, or merge series with other groups.
   5. Under Add axis, in the Groups box, select the group that you want to add the axis for, and then in the Axis position box, select where you want the axis to be displayed.
   6. Click Add.

   Remove an axis

   1. Click the axis you want to remove.
   2. Press DELETE.

   Change the position of an axis

   1. Click the axis you want to change.
   2. On the toolbar, click Commands and Options , and then click the Format tab.
   3. Under Position, in the Position box, select the option you want.

   Add, change, or remove a title on an axis

   Add a title

   1. Click the axis to which you want to add a title.

   2. On the toolbar, click Commands and Options , and then click the General tab.

   3. Click Add Title .

   Remove a title

   1. Click the title you want to remove.

   2. Press DELETE.

   Change a title

   1. Click the title you want to change.

   2. On the toolbar, click Commands and Options .

   3. Do one or more of the following:

      Change the text format

      1. Click the Format tab.

      2. Select the options you want under Text format.

      Change the title contents

      1. Click the Format tab.

      2. Under Caption, type a new title in the Caption box.

      Change the border or fill color

      1. Click the Border/Fill tab.

      2. Select the options you want under Border and under Fill.

   Change the font or size of the axis value text

   1. Click the axis text that you want to change.
   2. On the toolbar, click Commands and Options, and then click the Format tab.
   3. Under Text format, select the options you want.

   Change the spacing of tick marks and labels on the category axis

   Each category on the category axis is identified by a label and separated from other categories by tick marks. You can change the intervals at which labels and tick marks appear.

   1. Click the category axis you want to change.

   2. On the toolbar, click Commands and Options , and then click the Scale tab.

   3. Under Scale, do one or more of the following:
      • Type a number in the Labels spacing box to specify the frequency at which category labels must be labeled. For example, type 1 to label every category, type 2 to label every other category, and so on.
      • Type a number in the Tick mark spacing box to specify the number of categories you want between each pair of tick marks. For example, type 1 to have one category between each tick mark; or type 2 to have two categories between each tick mark.

   Change where the category axis crosses the value axis

   1. Click the category axis you want to change.
   2. On the toolbar, click Commands and Options , and then click the Scale tab.

   3. In the Crosses with list under Crossing Axis, click the axis that you want to cross the category axis.

   4. If you want to specify where the crossing axis should cross the category axis, select the Custom check box and then type a value in the box next to it.

   Change a timescale category axis

   When your category data is made up of numeric dates, the chart automatically uses a timescale axis. The timescale category axis displays dates in chronological order at specific intervals even if the dates in your data are not in order.

   1. Click the category axis you want to change.
   2. On the toolbar, click Commands and Options , and then click the Scale tab.
   3. Under Timescale, click an option in the Timescale box:

      None   Use a category axis that uses your dates as text labels rather than a timescale axis.

      Auto   The chart uses a timescale axis and determines the most appropriate Group size (that is, group dates by days, months, quarters, and so on) based on the axis scale.

      Manual   The chart uses a timescale axis, but you determine the most appropriate Group size (that is, group dates by days, months, quarters, and so on) for the axis based on your data.

   4. If you chose Auto or Manual in the previous step, select how you want dates displayed and totaled in the remaining options under Timescale.

   Reverse the direction of values on an axis

   1. Click the axis for which you want to reverse the direction of values.

   2. On the toolbar, click Commands and Options , and then click the Scale tab.

   3. Under Order, select the Show values in reverse order check box.

   Split values in an axis scale

   When you have very low and very high values in your chart, you can split the value axis (or timescale axis) so that all of the values are shown clearly. For example, if your values range from 0 to 950, with values falling between 0 and 100 and between 750 and 950, you can split the axis so that it has two scales: The bottom scale ranges from 0 to 100, and the top scale ranges from 750 to 950, thus eliminating unnecessary chart space between 100 and 750.

   

   1. Click the value axis that you want to split.
   2. On the toolbar, click Commands and Options , and then click the Axis tab.
   3. Select the Split axis check box, type a value in the Split begins at box (which marks the end of the first scale), and then type a value in the Split ends at box (which marks the beginning of the second scale).

   Change the line weight or color of the axis

   1. Click the axis line you want to change.
   2. On the toolbar, click Commands and Options , and then click the Line/Marker tab.
   3. Under Line, select the options you want.

   Change the number format of the axis values

   1. Select the value axis for which you want to change number formatting.
   2. On the toolbar, click Commands and Options , and then click the Format tab.
   3. Under Text format, in the Number box, click the format you want.

   Change the scale of a value axis

   The scale specifies the range of values on an axis, the way the axis values are displayed, the intervals at which the values occur, and the point at which one axis crosses another.

   1. Click the value axis you want to change.
   2. On the toolbar, click Commands and Options , and then click the Scale tab.
   3. Do one or more of the following:
      • Under Crossing Axis, select in the Crosses with box the axis you want to cross the value axis. If you want to specify where the crossing axis should cross the value axis, click Custom, and then type a value in the Custom box.
      • To specify either or both the highest and lowest values you want to appear on the axis, select the Custom max and/or Custom min check boxes, and then type the appropriate values in the adjacent boxes.
      • If you want to specify the intervals between major and/or minor tick marks and gridlines, select the Custom major unit and/or Custom minor unit check boxes, and then type the appropriate values in the adjacent boxes to specify the intervals you want.
      • To recalculate values on the axis based on a power of 10, 2, or e, select the Logarithmic scale check box, and then click the power you want to use in the Use base list.