Knowledge base KB0138

How do I set a colored pattern for a segment, area, or bubble?

For occasional use

  1. Left-click on the chart and check Use Excel Fill on Top in the color scheme control (see Color scheme).
  2. Open the chart's datasheet, select some cells, then right-click → Format Cells…Fill
  3. Set the desired combination of fill color and pattern in the dialog → OK.

Excel Format Cells… Dialog

In area charts, the fill color and pattern of the cell containing the series name determines the style for the whole series, across all categories. The fill color and pattern of individual data points' cells has no effect.

In bubble charts, the fill color and pattern can be applied to any cell that belongs to the respective data point.

Adding colored patterns as a standard option to think-cell menus

You have the option of customizing think-cell's menus on a per-file or per-template basis with think-cell style files as described in our user manual in Customizing think-cell. The pattern fill option is explained in Style file format.


think-cell uses cookies to improve the functionality, performance and security of this site. Your consent is necessary if you want to use the full functionality of this site. More information on the use of cookies by think-cell, your consent and your privacy rights can be found in our privacy policy.