This dialog is used to format any dotplot in-cell charts in your report.

For details about how to invoke the dialog, review In-cell chart designer.

The horizontal scale factor to use when drawing the chart

The color to draw the plots

There are two choices:

Based on the stacking type — the values will be grouped and drawn either varying the color or the vertical position:

Defines how dots are stacked​ — the number of values, an alternate set of values, or a random jitter:

Count: The Y value is defined by the number of values that are the same (only applied when the stacking type is Position or Color).

Values: Provide another range the same shape as the source values to enable plotting of specific X and Y values (only applied when the stacking type is Position or Color).

Jitter: The Y value is taken from a fixed set of random values to enable dots near each other to be easily distinguished (only applied when the stacking type is Position).

Defines the colors to use when stacking values.

OptionsDescription
Use title onlyDisplays the text in the header cell for the charts.
Axis with tickmarks aboveAxis will have tickmarks above the base line.
Axis with tickmarks belowAxis will have tickmarks below the base line.
Custom tickmark frequencyControls how often an axis value will be displayed.
Minor tick per major tickNumber of ticks to appear between each value.
Show labels on major ticksControls when to display the values.
Number formatSpecify the number format for the tickmarks.
Custom x-axis min and Custom x-axis maxControls the horizontal maximums and minimums.
Custom y-axis min and Custom y-axis maxControls the maximums and minimums for when stacking is enabled.