Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

2.4.243 Scatter

Office

The Scatter record specifies that the chart group is a scatter chart group or a bubble chart group, and specifies the chart group attributes.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

pcBubbleSizeRatio

wBubbleSize

A

B

C

reserved

pcBubbleSizeRatio (2 bytes): An unsigned integer that specifies the size of the data points as a percentage of their default size. A value of 100 shows all the data points in their default size, as determined by the application. MUST be greater than or equal to 0 and less than or equal to 300. MUST be ignored if the fBubbles field is 0.

wBubbleSize (2 bytes): An unsigned integer that specifies how the default size of the data points represents the value. MUST be ignored if the fBubbles field is 0. MUST be a value from the following table:

Value

Meaning

0x0001

The area of the data point represents the value.

0x0002

The width of the data point represents the value.

A - fBubbles (1 bit): A bit that specifies whether this chart group is a scatter chart group or bubble chart group. MUST be a value from the following table:

Value

Meaning

0

Scatter chart group

1

Bubble chart group

B - fShowNegBubbles (1 bit): A bit that specifies whether data points with negative values in the chart group are shown on the chart. MUST be ignored if the fBubbles field is 0.

C - fHasShadow (1 bit): A bit that specifies whether one or more data markers in a scatter chart group or data points in a bubble chart group have shadows.

reserved (13 bits): MUST be zero, and MUST be ignored.

Show:
© 2015 Microsoft