Version

Working with Bubble Chart Data

This topic discusses useful information that will help you to ensure that your data is rendered properly in the bubble chart.

Data Requirements

While the Chart control allows you to easily point the chart to your own custom data, it is important that you are supplying the appropriate amount and type of data that the chart requires. If the data does not meet the minimum requirements based on the type of chart that you are using, an error will be generated.

The following is a list of data requirements for bubble charts:

Mapping Data to Bubble Charts

The chart data is rendered using the following rules:

  • Each row represents one bubble with the last row in the data set appearing foremost in the foreground.

  • The first three numeric columns are included as ColumnX, ColumnY, and ColumnZ, in that specific order.

  • The columns at the indices specified by the ColumnX, ColumnY and ColumnZ properties will be used to determine the horizontal (X) position, vertical (Y) position, and radius (Z) of the bubble.

  • The first string column encountered in the data will be used for row labels.

  • You can include or exclude any row from the chart.

  • You can select an alternate column to be used for row labels, and toggle between the primary and secondary labels.

  • You can select alternate columns (or rows) for ColumnX, ColumnY, and ColumnZ.

  • Bubbles are drawn relative to each other. If there is only one bubble it will always be the same size regardless of its Z value.

  • Both the x-axis (horizontal) and y-axis (vertical) are numeric in bubble charts so that the data is plotted on a two-dimensional plane. Labels on both axes can be formatted using the FormatString property and a numeric format:

UltraChart.Axis.X.Labels.ItemFormatString = "<DATA_VALUE:##.##>"
UltraChart.Axis.Y.Labels.ItemFormatString = "<DATA_VALUE:##.##>"
Latitude Longitude Crimerate

0

0

2.36

120

25

6.69

-25

100

3.65

-80

-100

5.36

63

-12

8.56

156

75

5.36

-129

166

7.29

-175

-86

1.23

96

-177

4.69

36

111

2.354

-75

69

5.58

-99

-50

4.36

29

-143

6.24

Shows a 2D Bubble Chart based on the data listed in the table above.