Enhancing a Data Series

When you initially use the Chart Wizard, Excel automatically selects the colors that it will use to represent each data series. You can change one or all of the default colors. You may want more dynamic colors ”adding patterns and texture to further enhance a data series. Or, perhaps you'll be printing your charts in black and white and you want to ensure the readability of each data series. You can also insert a picture in a chart so that its image occupies a bar or column.

Change a Data Series Color or Pattern

graphics/one_icon.jpg

Click any data point in a data series to select it.

graphics/two_icon.jpg

Double-click a data point in the selected data series.

graphics/three_icon.jpg

Click the Patterns tab.

graphics/four_icon.jpg

Click a color in the Area palette. The selected color displays in the Sample box.

graphics/five_icon.jpg

If you want to add effects, such as textures, patterns, gradients, or pictures, click the Fill Effects button.

graphics/six_icon.jpg

Click the Gradient, Texture, or Pattern tab to change the qualities of the data series color.

graphics/seven_icon.jpg

When you're done, click OK.

graphics/eight_icon.jpg

Click OK if you're satisfied with the results shown in the Sample box, or select different options.

graphics/08inf31.jpg

graphics/08inf32.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net