Formatting options available for each visual type in Insights
Prerequisite
-
You have the Insights Author license.
Page location
Insights > Analyses > Click an analysis > Click a visual
The following list breaks down what type of formatting works in a visualization during analysis:
-
Bar charts (both horizontal and vertical) support the following formatting:
- Customize, display, or hide title, field labels, and data labels
- Customize, display, or hide legend (exception: simple charts without clustering or multiple measures don't show a legend)
- Specify axis range and steps on the x-axis for horizontal bar charts, and on the y-axis for vertical bar charts
- Choose how many data points to display on the x-axis for vertical bar charts, and on the y-axis for horizontal bar charts
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
- Customize, display, or remove reference lines
- Show or hide the “other” category
Horizontal bar charts support sorting on the y-axis and Value. Vertical bar charts support sorting on the x-axis and Value.
Stacked bar charts support showing totals.
-
Box plots support the following formatting:
- Customize, display, or hide title
- Customize, display, or hide legend
- Specify axis range and label tick on the x-axis and axis range and step on the y-axis
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
- Choose how many data points to display on the y-axis.
- Show or hide the “other” category
- Add reference lines
Box plots support sorting on Group By.
-
Combo charts support the following formatting:
- Customize, display, or hide title, field labels, and data labels
- Customize, display, or hide legend (exception: simple charts without clustering, stacking, or multiple measures don't show a legend)
- Specify axis range on bars and lines
- Synchronize the Y axes for both bars and lines into a single axis.
- Choose how many data points to display on the x-axis
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
- Customize, display, or remove reference lines
- Show or hide the "other" category
Combo charts support sorting on the x-axis, Bars, and Lines.
-
Donut charts support the following formatting:
- Customize, display, or hide title, data labels, and legend
- Customize, display, or hide the labels for group or color and value fields
- Choose how many slices to display from Group/Color
- Show or hide the "other" category
Donut charts support sorting on Group/Color and Value.
-
Filled maps support the following formatting:
- Customize, display, or hide title.
- Customize, display, or hide the legend
Filled maps support sorting on Location and Color.
-
Funnel charts support the following formatting:
- Customize, display, or hide title, and data labels
- Customize, display, or hide the labels for group or color and value fields
- Choose how many stages to display in the Group By field
- Show or hide the "other" category
Funnel charts support sorting on Group By and Value.
-
Gauge charts support the following formatting:
- Customize, display, or hide title. Display or hide axis labels.
- Customize how to display the value or values: hidden, actual value, comparison
- Choose the comparison method (available when you use two measures)
- Choose the axis range and padding to display in the gauge chart
- Choose the arc style (degrees from 180 to 360) and arc thickness
Gauge charts don't support sorting.
-
Geospatial charts (maps) support the following formatting:
- Customize, display, or hide title and legend
- Choose the base map image.
- Choose to display map points with or without clustering.
Geospatial charts don't support sorting.
-
Heat maps support the following formatting:
- Customize, display, or hide title, legend, and labels
- Choose how many rows and columns to display
- Choose colors or gradients.
- Show or hide the "other" category
Heat maps support sorting on Values and Columns.
-
Histogram charts support the following formatting:
- Customize, display, or hide title, field labels, and data labels
- Specify axis range, scale, and steps on the y-axis
- Choose how many data points to display on the x-axis
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
Histogram charts don't support sorting.
-
Key performance indicators (KPIs) support the following formatting:
- Customize, display, or hide title
- Display or hide trend arrows and progress bar
- Customize comparison method as auto, difference, percent (%), or difference as percent (%)
- Customize primary value displayed to be comparison or actual
- Conditional formatting
KPIs don't support sorting.
-
Line charts support the following formatting:
- Customize, display, or hide title, field labels, and data labels
- Customize, display, or hide legend (exception: simple charts don't show a legend)
- Specify axis range and steps (on y-axis)
- Choose how many data points to display on the x-axis
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
- Customize, display, or remove reference lines
- Customize the styling of lines and the markers for data points on a line
- Show or hide the "other" category, except when the x-axis is a date
Line charts support sorting on the x-axis and Value for numeric purposes only.
-
Pie charts support the following formatting:
- Customize, display, or hide title, data labels, and legend
- Customize, display, or hide the labels for group or color and value fields
- Show metrics as values, percentages, or both
- Choose how many slices to display from the Group/Color field
- Show or hide the "other" category
Pie charts support sorting on Value and Group/Color.
-
Pivot tables support the following formatting:
- Customize, display, or hide title
- Customize, display, or hide the labels for column, row, and value fields
- Customize the font sizes for table headers and cells/body
- Display or hide totals and subtotals on rows or columns
- Custom labels for totals or subtotals
- Choose additional styling options: fit table to view, hide +/- buttons, hide column field names, hide duplicate label when using single metric
- Conditional formatting
Pivot tables support sorting on Column and Row. For more information on sorting pivot table data, see Sort pivot tables in Insights.
-
Scatter plots support the following formatting:
- Customize, display, or hide title, legend, field labels, and data labels
- Customize, display, or remove reference lines
- Specify axis range (on x-axis and y-axis)
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
Scatter plots don't support sorting.
-
Tables support the following formatting:
- Customize, display, or hide title, legend, and columns
- Customize, display, or hide the column names for group-by and value fields
- Customize the font sizes for table headers and cells/body
- Display or hide totals at the top or bottom of the table
- Provide a custom label for totals
- Add conditional formatting
Tables support sorting on Group By and Value.
-
Tree maps support the following formatting:
- Customize, display, or hide title and legend
- Customize, display, or hide the labels for group-by, size, and color fields
- Choose colors or gradients.
- Choose how many squares to display from the Group By field
- Show or hide the “other” category
Tree maps support sorting on Size, Group By and Color.
-
Waterfall charts support the following formatting:
- Customize, display, or hide title or subtitle
- Customize the total label
- Specify x-axis label size and orientation and y-axis label range and orientation.
- Show or hide axis lines, axis labels, axis sort icons, and chart grid lines
- Show or hide the “other” category
- Customize the legend size and position.
- Customize and display or hide data labels.
Waterfall charts support sorting on Category and Value.
-
Word clouds support the following formatting:
- Customize, display, or hide title
- Customize the word color, and the number of words to display from the Group by field
- Show or hide the “other” category
- Choose additional styling options: allow vertical words, emphasize scale, or work with fluid layout, lowercase, padding level, or maximum string length
Word clouds support sorting on Group By.
Related topics