Axes in PowerPoint charts are typically positioned on the left and bottom of the plot area. But there may be scenarios when you want your axes to
cross each other within the plot area rather than be located on its edges, as shown in Figure 1, below.
Figure 1: Chart with crossed axes
Attaining such a crossed axes can be desirable due to a variety of reasons in both the Value and Category axes:
For Value Axes: With a Value axis, you may prefer this behavior when you have both positive and negative values, as is the case
with the data represented in Figure 1, above, retaining your axis at the zero level may be desirable so that negative values show
below the axis, and positive values are placed above. Fortunately, you do not have to do anything to cross the Value axis in such a scenario since
crossing for a chart that has both positive and negative values is the default behavior. Look at the data shown in Figure 2, note that it
has both positive and negative values.
Figure 2: Data with both positive and negative values
If the data shown in Figure 2, above is used to create a Column chart, then PowerPoint will automatically create
a chart with a crossed Value axis at the zero value point, as shown in Figure 3.
Figure 3: Value axis is crossed at the zero value point
However, you are not limited to retaining the crossing position of the axis at zero. There's no reason why it cannot be -2 or +2, or whatever you
want. Later in this tutorial, we will show you how you can alter the position where this axis is crossed.
For Category Axes: On the other hand, the reason to end up with a crossed Category axis differs. You may want a crossed Category
axis if you have too many categories, as already shown in Figure 3 above where we have 16 categories. In such a
scenario a leftmost placed axis may not help you ascertain column representation at the far right. Placing the axis in the center (see
Figure 1) may provide a better solution.
To learn how to add crossed axes in PowerPoint 2011, or to change the position where they cross, follow these steps:
- Let us begin with the Category axis. Select this axis, and right-click to bring up the contextual menu you see in
Figure 4. Choose the Format Axis option.
Figure 4: Format Axis option selected
- This brings up the Format Axis dialog box that you see in Figure 5. Make sure that the Scale
option is selected within the sidebar. Then, make sure that the Vertical axis crosses between categories check-box is selected as
shown highlighted in red within Figure 5.
Figure 5: Change the position where the Vertical axis crosses Horizontal axis
- After that, within the Vertical axis crosses at category number box (highlighted in blue within
Figure 5, above), type the category number before which the axis should move. We typed in 10 for our sample data.
The resultant chart can be seen in Figure 6.
Figure 6: Value axis crossing Category axis before 10th category
- This solution brings forth a problem of its own. The axes labels actually overlap one of the columns! To solve this problem, select and
right-click any chart element and choose Edit Data in the resultant contextual menu, as shown in Figure 7.
Figure 7: Select Edit Data option
- This brings up the same data that we last saw in Figure 2. We will now insert a blank row after the 9th row, and while we leave
the Category name blank, we will add a zero value for the Profits column, as shown in Figure 8, below.
Figure 8: Blank row added within the Excel data sheet
- The resultant chart is so much clearer, notice the empty area that displays your Category axis labels so well in Figure 9,
below. Do compare Figures 6 and 9 to see this difference!
Figure 9: A cleaner crossed axis
- Now for the Value axis, notice that the Value axis is already at the zero level (see
Figure 9), with negative values below the axis, and positive ones above. Ideally, this is exactly how this should be, so the only
reason we are showing you how to change this crossed location is so that you can be aware of how to manually make this change. Select the
Value axis, and right-click to bring up the contextual menu you saw in Figure 4. Choose the
Format Axis option.
- This brings up the Format Axis dialog box that you see in Figure 10. Make sure that the Scale
option is selected within the sidebar. Also make sure that you deselect the Horizontal axis crosses at check-box to take it off
Auto mode, and then enter -6 within the box as shown highlighted in red within
Figure 10. Once done, click the OK button.
Figure 10: Change the position where the Horizontal axis crosses the Vertical axis
- Note that since 0, the figure we used for the inserted blank row (see Figure 8) is larger than our new base level of -6, it ends
up displaying a column, as shown highlighted in red within Figure 11.
Figure 11: Data in Blank row causes a new column to appear
- Go back to your Excel data sheet and change the value for the blank cell to match the new base level (-6), as shown in Figure 12.
Figure 12: Changed data for the blank row
This will make the display look better as you can see in Figure 13.
Figure 13: A cleaner crossed axis
- Now that you have learned how you can change the position at which axes cross each other, you may want to make the axes more prominent by
changing their color and thickness. This is easily achieved by first selecting the axis, and right-click to bring up the contextual menu you last saw
in Figure 4. Choose the Format Axis option. Make sure that the Line option (highlighted in
red within Figure 14) is selected within the sidebar. Then select the Solid tab
(highlighted in blue within Figure 14) and change the axis color as shown in
Figure 14.
Figure 14: Change the color of the selected axis
- Then select the Weights & Arrows tab (highlighted in red within Figure 15) and
change the thickness of the axis, as in Figure 15 you can see that we have changed the thickness (weight) to 3 points (highlighted
in blue within Figure 15).
Figure 15: Change the line weight of the selected axis
The resultant chart will be something like what you see in Figure 16. And if you have crossed the Value axis at the zero level, you can see how this effects the resultant chart as shown in Figure 1, previously on this page.
Figure 16: Chart with formatted crossed axes
- Save your presentation often.
See Also:
Crossed Axes for Charts in PowerPoint 2013 for Windows
