Introduction
  Welcome
  The Web Reporting Solution
  What is ExcelWriter?
  Features and Benefits
  New in This Version  V4
  Requirements
  Edition Differences
  Frequently Asked Questions
  Troubleshooting

Quick Start
  Creating Your First Spreadsheet
  Adding a Formula
  Adding Formatting
  Importing from a Database

Features In Depth
  Addressing Cells
  Setting Values
  Output Options
  Adding Charts
  Reading an Existing Spreadsheet
  Modifying an Existing Spreadsheet
  The Range Object
  Template Spreadsheets
  How to Use Templates
  ExcelApp.Open vs. ExcelTemplate
  Using ExcelTemplate with PivotTables
  Templates and Charts
  Reliable Spreadsheet Download  V4
  Page Setup
  Formatting Headers & Footers
  Protecting your Worksheet
  Multilingual Support  V4
  XML Import

HotCell Technology  V4
  What is HotCell Technology?
  Upload Example
  Advanced POST Example
  Advanced Upload Example

Programmer's Reference
  Object Model
      ExcelTemplate Object
      ExcelApplication Object
         3DProperties Object
         Area Object
         Axis Object
         Cells Object
         Cell Object
         Charts Object
         Chart Object
         ChartFrame Object
         Font Object
         Line Object
         PageSetup Object
         Pictures Object
         Picture Object
         Range Object
         SeriesCollection Object
         Series Object
         Style Object
         Worksheets Object
         Worksheet Object
  Formula Functions
  Formula Calculation Operators
  Formatting Codes
  Chart Codes

Installation
  Quick Installation
  Configuring IIS
  Security Considerations

External Links
  ExcelWriter Home Page
  Technical Support
  ExcelWriter Demos
  SoftArtisans Home Page
  E-mail General Questions
  E-mail Technical Support
  Legal Information
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


This chart type not available in 
Excel 95 (BIFF7 format).
0 (default)
 
Column Line 2 Axes Chart
	
Name: saxlsColumnLine2AxesChart
Number: 14
0 (default)
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 © 2003, SoftArtisans, Inc.