Show code in...     

  

 
Column Chart Pie Chart Line Chart Radar Chart Bar Chart
Surface Chart Area Chart Scatter Chart Doughnut Chart Bubble Chart Cylinder Chart
Cone Chart Pyramid Chart Column Line Chart Column Line 2 Axes Chart

Chart Codes

When you add a chart to your worksheet using the Add method, you must specify a chart type by name (e.g. saxlsCylinderChart) or number. You may also specify a subtype; if you do not, ExcelWriter will use the default subtype. ExcelWriter currently supports fifteen major Excel chart types and over seventy subtypes. The type and subtype codes are listed below.

Note: ExcelWriter is not a charting engine and cannot be used to produce static gif or jpeg representations of charts for inclusion in an HTML page.

What Chart Types are Available in ExcelWriterSE and ExcelWriterLE?

The chart types available in ExcelWriterSE and ExcelWriterLE are bar, column, and pie. (ExcelWriter Enterprise Edition offers all chart types listed below.)

Chart types and Codes Subtypes and Codes 
Column Chart
	
Name: saxlsColumnChart
Number: 0
0 (default)Clustered column
1Stacked column
2100% stacked column
33D clustered column
43D stacked column
53D 100% stacked column
63D column
 
Pie Chart
	
Name: saxlsPieChart
Number: 1
0 (default)Pie
13D Pie
2Pie of pie
3Exploded Pie
43D Exploded Pie
5Bar of pie
 
Line Chart
	
Name: saxlsLineChart
Number: 2
0 (default)Line
1Stacked line
2100% stacked line
3Line with data markers
4Stacked line with data markers
5100% stacked line with data markers
63D line
 
Radar Chart
	
Name: saxlsRadarChart
Number: 3
0 (default)Radar
1Radar with data markers
2Filled radar
 
Bar Chart
	
Name: saxlsBarChart
Number: 4
0 (default)Clustered bar
1Stacked bar
2100% stacked bar
33D clustered bar
43D stacked bar
53D 100% stacked bar
 
Surface Chart
	
Name: saxlsSurfaceChart
Number: 5
0 (default)3D surface
1Wireframe 3D surface
2Contour
3Wireframe contour
 
Area Chart
	
Name: saxlsAreaChart
Number: 6
0 (default)Area
1Stacked area
2100% stacked area
33D area
43D stacked area
53D 100% stacked area
 
Scatter Chart
	
Name: saxlsScatterChart
Number: 7
0 (default)Scatter
1Scatter connected by curves, with data markers
2Scatter connected by curves, without data markers
3Scatter connected by lines, with data markers
4Scatter connected by lines, without data markers
 
Doughnut Chart
	
Name: saxlsDoughnutChart
Number: 8
0 (default)Doughnut
1Exploded doughnut
 
Bubble Chart
	
Name: saxlsBubbleChart
Number: 9

This chart type not available in 
Excel 95 (BIFF7 format).
0 (default)Bubble
13D bubble
 
Cylinder Chart
	
Name: saxlsCylinderChart 
Number: 10


This chart type not available in 
Excel 95 (BIFF7 format).
0 (default)Cylinder
1Stacked cylinder
2100% stacked cylinder
3Cylindrical bar
4Stacked cylindrical bar
5100% stacked cylindrical bar
63D cylindrical column
 
Cone Chart
	
Name: saxlsConeChart 
Number: 11


This chart type not available in 
Excel 95 (BIFF7 format).
0 (default)Cone
1Stacked cone
2100% stacked cone
3Conical bar
4Stacked conical bar
5100% stacked conical bar
63D conical column
 
Pyramid Chart
	
Name: saxlsPyramidChart 
Number: 12


This chart type not available in 
Excel 95 (BIFF7 format).
0 (default)
1Stacked pyramid
2100% stacked pyramid
3Pyramid bar
4Stacked pyramid bar
5100% stacked pyramid bar
63D pyramid column
 
Column Line Chart
	
Name: saxlsColumnLineChart
Number: 13
0 (default)
1Stacked
2100% stacked
 
Column Line 2 Axes Chart
	
Name: saxlsColumnLine2AxesChart
Number: 14
0 (default)
1Stacked
2100% stacked
Column Chart Pie Chart Line Chart Radar Chart Bar Chart
Surface Chart Area Chart Scatter Chart Doughnut Chart Bubble Chart Cylinder Chart
Cone Chart Pyramid Chart Column Line Chart Column Line 2 Axes Chart

Copyright © 2005, SoftArtisans, Inc.