Creates a chart in an Excel Document.
ExcelChartWriterModifier
| Name | Type | Description |
|---|---|---|
| ChartTitle | string | Title of the chart |
| ChartType | name | Indicates type of chart to create. Choices are :Area3D, :AreaStacked3D, :AreaStacked3D100, :BarClustered3D, :BarStacked3D, :BarStacked3D100, :Column3D, :ColumnClustered3D, :ColumnStacked3D, :ColumnStacked3D100, :Line3D, :Pie3D, :PieExploded3D, :Area, :AreaStacked, :AreaStacked100, :BarClustered, :BarOfPie, :BarStacked, :BarStacked100, :Bubble, :Bubble3D, :ColumnClustered, :ColumnStacked, :ColumnStacked100, :ConeBarClustered, :ConeBarStacked, :ConeBarStacked100, :ConeColumn, :ConeColumnClustered, :ConeColumnStacked, :ConeColumnStacked100, :CylinderBarClustered, :CylinderBarStacked, :CylinderBarStacked100, :CylinderColumn, :CylinderColumnClustered, :CylinderColumnStacked, :CylinderColumnStacked100, :Doughnut, :DoughnutExploded, :Line, :LineMarkers, :LineMarkersStacked, :LineMarkersStacked100, :LineStacked, :LineStacked100, :Pie, :PieExploded, :PieOfPie, :PyramidBarClustered, :PyramidBarStacked, :PyramidBarStacked100, :PyramidColumn, :PyramidColumnClustered, :PyramidColumnStacked, :PyramidColumnStacked100, :Radar, :RadarFilled, :RadarMarkers, :StockHLC, :StockOHLC, :StockVHLC, :StockVOHLC, :Surface, :SurfaceTopView, :SurfaceTopViewWireframe, :SurfaceWireframe, :XYScatter, :XYScatterLines, :XYScatterLinesNoMarkers, :XYScatterSmooth, :XYScatterSmoothNoMarkers |
| DataSeries | string | Worksheet range(s) to be used as the series in the chart |
| DataSeriesLabels | string | Labels for data series |
| DependentParts | list | Specifies the set of other processor parts that must be processed before this one |
| PlotBy | name | Indicates whether to plot by rows or columns. Choices are :ByColumns, :ByRows; default is :ByColumns. |
| ProcessSelf? | boolean | Specifies whether the ExcelChartWriter child will be processed when the Excel document Process rule is evaluated. Default is True . |
| Range | string | Range of cells in worksheet to where data will be written. |
| Sheet | string | Specifies the sheet within the workbook that this part will access |