Microsoft Office Tutorials and References
In Depth Information
Chapter 10: Charming Charts and Gorgeous Graphics
✓ Text Fill button to select a new fill color for the text in the selected chart
title from its gallery
✓ Text Outline button (immediately below the Text Fill button) to select
a new outline color for the text in the selected chart title from its
✓ Text Effects button (immediately below the Text Outline button) to
apply a text effect (Shadow, Reflection, Glow, Bevel, and so on) to the
text of the selected chart title from its drop-down list
Formatting the x- and y-axis
When charting a bunch of values, Excel isn’t too careful how it formats the
values that appear on the y-axis (or the x-axis when using some chart types,
such as the 3-D Column chart or an XY Scatter chart).
If you’re not happy with the way the values appear on either the x-axis or
y-axis, you can easily change the formatting as follows:
1. Click the x-axis or y-axis directly in the chart or click the Chart
Elements button (the first button in the Current Selection group of the
Format tab) and then click Horizontal (Category) Axis (for the x-axis)
or Vertical (Value) Axis (for the y-axis) on its drop-down list.
Excel surrounds the axis you select with selection handles.
2. Click the Format Selection button in the Current Selection group of
the Format tab.
Excel opens the Format Axis task pane with Axis Options under the Axis
Options group selected.
3. To change the scale of the axis, the appearance of its tick marks, and
where it crosses the other axis, change the appropriate options under
Axis Options (automatically selected when you first open the Format
Axis task pane) as needed.
These options include those that fix the maximum and minimum amount
for the first and last tick mark on the axis, display the values in reverse
order (highest to lowest), and apply a logarithmic scale. 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.
4. To change the number formatting for all values on the selected axis,
click the Number option and then select the number format you want to
apply in the Category drop-down list box followed by the appropriate
options associated with that format. 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.