Microsoft Office Tutorials and References
In Depth Information
Adding unattached text to a chart
ivor y border
around the text box
Now that you have formatted the chart labels and added unattached text, you can turn
to some of the other features of Excel charts that need modifying.
Working with Colors and Fills
The formatted data labels and the unattached text help to clarify the sales data, but Alicia
feels that the column chart lacks visual appeal. Alicia has seen objects filled with a variety
of colors that gradually blend from one color to another. She wonders if you can do the
same thing for the columns in the column chart. One idea she has is to make the columns
appear more like tubes, such as telescope tubes.
When you want to fill a column (or area) in a chart with a pattern or color, you are
actually modifying the appearance of the data marker in the chart. You will concentrate
only on the fill color used in the data marker. Other data markers have other patterns that
you can modify. For example, in an XY (scatter) chart, the data markers are points that
appear in the plot. You can specify the color of those data points, their size, whether a line
will connect the data points and, if so, the color, thickness, and style of that line.
You will format the data markers in the column chart beginning with the column that
represents the BrightStar 6 telescope.
To format the fill color of the chart columns:
1. Double-click the first column on the left in the chart to open the Format Data Series dialog
box for that data series. You can use the options available on the different dialog box tabs
to control one or more aspects of the selected data marker. For example, you use the
options provided on the Patterns tab to control the border style that appears around the
column as well as the interior appearance of the column. Currently, the column is format-
ted with a black border and filled with a pale-blue color.