Dundas Chart for SharePoint Send comments on this topic.
Data Requirements Of Chart Types
See Also

Glossary Item Box

Overview

All data is plotted as series, and each series consists of a related group of data points. This topic discusses some data requirements, and how those requirements relate to various chart types.

 

Data Points

Each data point consists of:

 

Note
When adding data points to a data series, you do not have to specify the X value since data is automatically plotted along the x-axis for you. (e.g. the X value for all data points in a series can be zero). When all X values are zero, data is plotted sequentially starting from zero.

 

Data Series

The Series object's ChartType property determines how a series is drawn.

 

Note
For more information on chart types, refer to the topics in the "Chart Types" folder for a complete description of each chart type.

 

The following table summarizes the number of data series, and Y values required for each chart type:

Chart Type

Minimum Number of Series

Maximum Number of Series

Number of Y-Values

100% Stacked Area Chart

1

unlimited

1

100% Stacked Bar Chart

1

unlimited

1

100% Stacked Column Chart

1

unlimited

1

Area Chart

1

unlimited

1

Bar Chart

1

unlimited

1

 Box Plot Chart

1

unlimited

>= 6

Bubble Chart

1

unlimited

2

Candlestick Chart

1

unlimited

4

Column Chart

1

unlimited

1

Doughnut Chart

1

1

1

 Error Bar Chart

1

unlimited

3

 FastLine Chart

1

unlimited

1

 FastPoint Chart

1

unlimited

1

 Funnel Chart

1

1

1

 Gantt Chart

1

unlimited

2

Line Chart

1

unlimited

1

Pie Chart

1

1

1

Point Chart

1

unlimited

1

 Polar Chart

1

unlimited

1

 Pyramid Chart

1

1

1

 Range Chart

1

unlimited

2

 Range Column Chart

1

unlimited

1

 Radar Chart

1

unlimited

1

Spline Area Chart

1

unlimited

1

Spline Chart

1

unlimited

1

 Spline Range Chart

1

unlimited

2

Stacked Area Chart

2
(if 1, acts like an Area Chart)

unlimited

1

Stacked Bar Chart

2
(if 1, acts like a Bar Chart)

unlimited

1

Stacked Column Chart

2
(if 1, acts like a Column Chart)

unlimited

1

Step Line Chart

1

unlimited

1

Stock Chart

1

unlimited

4

See Also