Scatter (No Aggregation)
Last updated
Last updated
X-Axis - Assign a column you want to show at X-Axis. If it is a date / time column assigned, the axis will be automatically in time series. If it is a number based column, the axis will be for the continuous values. If it is a text based column, the axis will be for discrete values.
Y-Axis - Assign a column you want to show at Y-Axis. The assigned column is handled in the same way as X-Axis.
Size - Assign a column you want to apply the size on each circle. You can assign a number based column only.
Color - Take a look at Color section for more details.
Repeat By - You can assign a column to repeat the chart for each of its values. Take a look at Repeat By section for more details.
You can assign multiple columns to Y-Axis. Take a look at Multiple Y-Axis section for more details.
Take a look at Trend Line section for more details.
Take a look at Reference Line section for more details.
Take a look at Range section for more details.
You can draw circles for each color group. It is useful to see the distributions of each group. You can access the Circles for Color feature from the Color property dialog that you can access by clicking the gear icon at the Color control.
Following circle types are available.
Circles - Circles without fill colors
Filled Circles - Circles filled with colors
You can change the color of the specific markers such as bars, lines or circles that you pick to stand out from others. See Highlight for the detail.
You can use the Rename Column Names feature to update column names if you assign multiple columns to Y-Axis. See Rename Column Names for the detail.
If you have many categories, you can reduce the number of categories by changing some category names to 'Others' using the 'Others' Group feature. See 'Others' Group for the detail.
You can use the Axis Setting feature to assign columns to Y1/Y2 axes if you assign multiple columns to Y-Axis. See Axis Setting for the detail.
You can show the detailed data underlying the chart by clicking the chart figure. See Show Detail for the detail.
Take a look at Layout Configuration on how to configure the layout and format.
On Windows with some hardware and driver, 3D scatter chart may not work. In that case, you can install DirectX 9 redistributable to make it work.
You can save the chart as an image file. See Save as PNG/SVG for more details.
Z-Axis - Assign a column you want to show at Z-Axis. By assigning Z-Axis, the chart becomes 3D Scatter chart. The assigned column is handled in the same way as X-Axis. Note that on Windows with some hardware and driver, 3D scatter chart may not work. In that case, you can install DirectX 9 redistributable to make it work.
Label - Assign a column you want to show in the balloon help that you see when you hover the marker such as dots. If you check the Show on plot
option, the column values directly come up in the plot area.