The Area Object (SAArea)
* The Area object is not available in ExcelWriterSE, ExcelWriterLE,
or ExcelWriterFree.
The Area object represents the appearance of a chart area. ExcelWriter includes the following area
objects:
Area Methods and Properties
*This feature is not available in
ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.
Area Methods and Properties
|
| AreaFormatting* |
Sets or retrieves the type of formatting applied to an Area object.
The three types of formatting and their codes are,
| saxlsCreationAutomatic | 0 |
| saxlsCreationNone | 1 |
| saxlsCreationCustom | 2 |
When AreaFormatting is set to saxlsCreationAutomatic (0), the default formatting settings will be applied to
the Area object. SaxlsCreationCustom (2) enables custom formatting assigned to the Area object (colors or pattern).
SaxlsCreationNone will remove all Area formatting (default or custom).
The following sets the ChartArea's AreaFormatting to saxlsCreationNone, disabling all ChartArea formatting.
chart.chartarea.area.AreaFormatting = 1
Top |
| BackgroundColor* |
Sets or retrieves the background color of an Area object
(Series Area,
MarkerFormat,
Wall3D, or
ChartFrame Area). Use
RGB values to assign colors, as in the following example.
chart.chartarea.area.backgroundcolor = rgb(0,0,255) '--- blue
Top |
| ForegroundColor* |
Sets or retrieves the foreground color of an Area object
(Series Area,
MarkerFormat,
Wall3D, or
ChartFrame Area). Use
RGB values to assign colors, as in the following example.
chart.chartarea.area.foregroundcolor = rgb(255,0,0) '--- red
Top |
| Pattern* |
Sets or retrieves the background pattern of an Area object
(Series Area,
MarkerFormat,
Wall3D, or
ChartFrame Area). ExcelWriter
supports nineteen patterns, listed in the table below.
| No Pattern | 0 |
| 0% Pattern | 1 |
| 50% Pattern | 2 |
| 70% Pattern | 3 |
| 25% Pattern | 4 |
| Dark Horizontal | 5 |
| Dark Vertical | 6 |
| Dashed Downward Diagonal | 7 |
| Dashed Upward Diagonal | 8 |
| Small Checkerboard | 9 |
| Trellis | 10 |
| Light Horizontal | 11 |
| Light Vertical | 12 |
| Wide Downward diagonal | 13 |
| Dark Upward diagonal | 14 |
| Small Grid | 15 |
| 60% Pattern | 16 |
| 20% Pattern | 17 |
| 10% Pattern | 18 |
The following example demonstrates setting the legend pattern to Small Grid.
chart.chartarea.area.pattern = 15
Top |
| *This feature is not available in
ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.
|
Copyright © 2003, SoftArtisans, Inc.