9.6.2 The (Plot Details) Data Tab
The Data tab is available when:
- The source plot is a box chart displaying the binned data. (In the Box tab, select Data, Box + Data Overlap, Box(Right) + Data(Left),Box(Left) + Data(Right), Bar + Data Overlap, Bar(Right) + Data(Left), Bar(Left) + Data(Right), Half Box(Right) + Data(Left) or Half Box(Left + Data(Right) under the Type drop-down List.)
- The source plot is a histogram, a column scatter plot or a violin plot.
Data tab for Box Chart, Column Scatter or Violin Plot
This group of settings is only available when the source plot is a box chart displaying the binned data or a column scatter plot.
Select Dots, Bin Bars, or Dots + Bin Bars from the Type drop-down list. The Dots option shows the individual binned data points; Bin Bars shows the data in histogram-like style, with bars as the specified bin size.
Select the Single Block Barplot check box to remove the lines between bins when Bin Bars or Dots + Bin Bars is selected from the Type drop-down list.
(Bins are shown here left-aligned.)
Select the Snap Points to Bin check box to align the binned data points horizontally in the bins. Note that if Jitter Points has been selected, this option will be disabled.
When the Type is not Bin Bars (i.e. you have dots to represent data), select the Jitter Points check box to add random noise in X direction to scatter out the data point series. This produces the random jitter, while in the Bins Alignment group, you could produce and customize the regular jitter.
The random offset in X direction is determined according to a normal distribution.
Extend Data Points
When shows the data point or quartile lines, it will extend these data sticks or short lines within distribution curves or the percentage of box width.
When Curve Type is not None and Show Symmetric Distribution Curve is selected in Distribution tab, <Auto> means extend data points within distribution curve. Otherwise, <Auto> means 100% of box width.
And when Curve Type is not None and Show Symmetric Distribution Curve is selected in Distribution tab, <Auto> will only apply the rule width distribution curve, and only apply to elements on the same side of distribution curve. Elements on the other side will not extend.
Available for Histogram only:
- Count: Y axis displays bin counts.
- Relative Frequency: Y axis displays individual bin counts divided by total count.
- Density: Y axis displays relative frequency (no. of observations in a given bin) divided by bin width.
To modify axis scale, see The Axis Dialog Scale Tab controls.
Edit the bin limits by clearing the Automatic Binning check box and editing the associated text boxes, Bin Size, Number of Bins, Beginning, and End.
Number of Bins = (Beginnning-End) / Bin Size
The radio box under the Automatic Binning check box is used to specify how to divide the bins. When you select By Increment, you can enter a fixed size for bins in the Bin Size text box. When you select By Intervals, the Number of Bins text box will be editable.
Bin Height (0-100)
Set the height of each bin. This text box is only available when the source plot is a box chart displaying the binned data. Since the bins are displayed on their sides, this value corresponds to the width of the data point display.
This group of settings is only available when the source plot is a box chart displaying the binned data.
Data Width (%)
Selected or typed a factor to control the data width in the combo box. This is a percent and only values from 0 to 100 are acceptable.
- <auto> means following Box Width in the Box tab.
- 0 means data points align in a line.
- This control group can be also used for regular jitter (i.e. evenly distribute points in X direction) when Jitter Points is unchecked. To adjust the data width for random jitter, you have to make sure the Jitter Points box is checked in the Type group.
Select Add Distribution Curves to add the distribution curves data to the bin worksheet. When you click the Go button, a Bin workbook containing the computed quantities of bins will be created, and the Plot Details dialog will be closed.