• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

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

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

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

Click the Patterns tab.

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

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

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

When you're done, click OK.

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


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint