Chart Settings Reference

Each chart type can be customized using the available settings. Click the Settings to open the Settings for your report.

These are the available settings. Each visualization uses a different subset of these settings.

Auto Format Format numbers to use K for thousands, M for Millions and so on. For example: 2450 appears as 2.45K, 5870000 appears as 5.87M.
Applies to: All Types
Values: Yes/No
Axis Alignment Show the Y-Axis at the left or right of the chart for each column on Y-Axis.
Applies to: Bar
Values: Left Axis, Right Axis
Axis Label Length Number of characters to show in axis labels.
Applies to: Bar
Values: Numeric
Axis Label Size Size in pixels for labels displayed on the axis of the bar chart.
Applies to: Bar
Values: Numeric
Axis Label Style Controls the font size and length for labels used on the X-Axis and Y-Axis.
Applies to: Bar
Values: Yes/No
Background Use transparent background or default background.
Applies to: Metric
Values: Yes/No
Border Show/Hide border around each metric.
Applies to: Metric
Values: Yes/No
Chart Type Type of plot to be used for every column on the Y-Axis.
Applies to: Bar
Values: none, line, bar, dot, area, stack
Chart Type color Color to be used to plot the column on the Y-axis.
Applies to: Bar
Values: Depend on the color palette selected.
City, Source City, Target City Column to be used for location city if Lat-Long mode is set to off.
Applies to: Map
Values: List of available non-aggregate columns
Color Measure Select which non-aggregate column should be mapped to the color of the rectangle.
Applies to: Treemap
Values: List of available non-aggregate columns
Colors Select the column based on which color variation would be applied to the data.
Applies to: Grid Chart
Values: List of available columns
Color Palette Select palette for displaying charts graphs or maps.
Applies to: Bar, Pie, Map, gMap
Values: Available color palettes for selected visualization
Columns Select fields to display in columns.
Applies to: Grid Chart
Values: List of available columns
Columns for Metadata Columns to be mapped on the Y-Axis.
Applies to: Bar
Values: Selected aggregate columns
Columns to hide Option to hide selected columns.
Applies to: Metric
Values: All selected columns
Country, Source Country, Target Country Column to be used for location country if Lat-Long mode is set to off.
Applies to: gMap
Values: List of available non-aggregate columns
Data Labels Show or hide the exact column value on the chart as a label.
Applies to: Bar
Values: Yes/No
Data Label Style Data label style for the bars. Available if Data Labels = Yes.
Applies to: Bar
Values: Yes/No
Data Label Style - Label position Position of the label in percentage x and y coordinates relative to the bar where it is displayed. For example, x=50 centers the label across the width of the bar.
Applies to: Bar
Values: 0-100
Data Label Style - Rotate Label Orientation of the label in degrees. Use 0 for horizontal labels and 90 for vertical labels.
Applies to: Bar
Values: 0-90
Dimension Column to be used for mapping the pie chart.
Applies to: Pie
Values: Selected non-aggregate columns
Fill Container Select if chart should fill the width of the container.
Applies to: Grid Chart
Values: Yes/No
Fill Space Select Yes to merge any empty columns in the last row after distributing data points available amongst number of columns selected.
Applies to: Metric
Values: Yes/No
Font Size Select the font size for the Data Label.
Applies to: Grid Chart
Values:
Grand Total Show or hide a row for grand totals at the end of the grid or chart.
Applies to: Table, Bar, Grid Chart
Values: Yes/No
Hide Label Show/hide labels for all metrics.
Applies to: Metric
Values: Yes/No
Hide Legend Show or hide the legend for colors used for every column on the Y-Axis.
Applies to: Bar
Values: Yes/No
Hide Range Legend Show or hide the range legend when ranges are defined using Range.
Applies to: Bar
Values: Yes/No
Hide X Axis Show or hide the labels on the X-Axis.
Applies to: Bar
Values: Yes/No
Hide Y Axis Show or hide the labels on the Y-Axis.
Applies to: Bar
Values: Yes/No
HTML Specifies formatting for the columns displayed in the metric.
Applies to: Metric
Values: Valid HTML for each of the selected columns.
Index Column Show or hide the index column that appears as the first column in the grid displaying the row index.
Applies to: Table
Values: Yes/No
Label Font Size Font Size of Label.
Applies to: Metric
Values: Range 1 to 100
Labels Select the column to display inside a rectangle.
Applies to: Treemap
Values: List of available columns
Lat-Long Mode Used if data contains location coordinates instead of names of places.
Applies to: Map, gMap
Values: Yes/No
Latitude, Source Latitude, Target Latitude Column used to map the latitude if Lat-Long Mode is Yes.
Applies to: Map, gMap
Values: List of available non-aggregate columns
Legend Scroll Enable scrolling for long legends.
Applies to: Bar
Values: Yes/No
Legend Show Displays a legend.
Applies to: Bar
Values: Yes/No
Limit Column Width Select if column width for all columns should be limited/optimized.
Applies to: Grid Chart
Values: Yes/No
Longitude, Source Longitude, Target Longitude Column used to map the longitude if Lat-Long Mode is Yes.
Applies to: Map, gMap
Values: List of available non-aggregate columns
Map Theme Apply one of the available themes.
Applies to: gMap
Values: Standard, Snow, Retro, Gray, Blue
Map Type Type of map to be generated.
Applies to: Map, gMap
Values: Geo Map, Scatter, Network, Path
Measure Column used to calculate the portions of the pie.
Applies to: Pie
Values: Selected aggregate columns
Measure, Primary Measure, Secondary Measure Column used for mapping data values on the map.
Applies to: Map, gMap
Values: List of available aggregate columns
Measures Scrollable Select if horizontal scroll should be available.
Applies to: Grid Chart
Values: Yes/No
Merge Cells Select if rows or columns with same values should be merged.
Applies to: Grid Chart
Values: Yes/No
Nav Bar Show or hide the pagination or navigation bar on top of the data grid.
Applies to: Table
Values: Yes/No
No Data Label Text to show when there is no data.
Applies to: Metric
Values: Free Text
Node Type Node type to show on the graph.
Applies to: Graph
Values: Box, Scatter
Number of Columns Number of columns to split the sheet screen into when displaying the selected columns as a metric.
Applies to: Metric
Values: Range 1 to number of selected columns
Orientation Orientation of the chart or legend.
Applies to: Bar, Line, Scatter, Area, Pie, Funnel, Box Plot, Heat Map
Values: Horizontal or Vertical
Percent on Chart Show percentage on the chart.
Applies to: Pie
Values: Yes/No
Percent on Tooltip Show percentage on the tooltip.
Applies to: Pie
Values: Yes/No
Quick View Can be used to view the data in a simple grid without pivot.
Applies to: Grid Chart
Values: Yes/No
Range Uses different colors for different range of values. You are prompted to key in the ranges and select colors for each range.
Applies to: Bar, Metric
Values: Yes/No
Reference Line Include one or more reference lines for specific values, define a label to display along the line, select the color and type of the line.
Applies to: Bar
Values: Yes/No with the option to choose value, label, color and line type when Yes is selected.
Reverse Show label under the value when reversed.
Applies to: Metric
Values: Yes/No
Rows Select fields to display in rows.
Applies to: Grid Chart
Values: List of available columns
Segment Column Column to be used for segmentation.
Applies to: gmap (Path Map)
Values: List of available columns
Serial Numbers Select if serial number should be shown for rows.
Applies to: Table, Grid Chart
Values: Yes/No
Show Breadcrumb Select if the breadcrumb should be displayed.
Applies to: Treemap
Values: Yes/No
Show Color indicator Select if the color indicator should be displayed.
Applies to: Treemap
Values: Yes/No
Show Label Show/Hide the data mapped in dimension column as labels near each slice of the pie.
Applies to: Pie
Values: Yes/No
Show Labels Attribute Name Select if column names should be included when displaying labels.
Applies to: Treemap
Values: Yes/No
Show Legend Displays a legend.
Applies to: Bar
Values: Yes/No
Show Tooltips Attribute Name Select if column names should be included when displaying tooltips.
Applies to: Treemap
Values: Yes/No
Show Table Name in Header Used to show the table name along with the column names in the column header.
Applies to: Table
Values: Yes/No
Size Measure Select which non-aggregate column should be mapped to the area of the rectangle.
Applies to: Treemap
Values: List of available non-aggregate columns
Source Column to be mapped as source nodes.
Applies to: Graph
Values: List of available columns
Spacing between Rows Spacing between Label and Text.
Applies to: Metric
Values: Range 1 to 100
Stack Bars Stack multiple dimensions in the same bar using different colors.
Applies to: Bar
Values: Yes/No
State, Source State, Target State Column used for location state or country if Lat-Long mode is No.
Applies to: Map
Values: List of available non-aggregate columns
Target Column to be mapped as target nodes.
Applies to: Graph
Values: List of available columns
Text Font Size Font Size of Text/Data
Applies to: Metric
Values: Range 1 to 100
Tooltips Select which column data should be displayed in a tooltip
Applies to: Treemap
Values: List of available columns
Transpose Measures Provides pivot view for the data where the aggregate measure columns are transposed to rows.
Applies to: Table
Values: Yes/No
Type Type of Pie Chart
Applies to: Pie
Values: Pie, Doughnut
Value Column to display value on graph connectors
Applies to: Graph
Values: List of available columns
X Axis Column to be mapped on the X-Axis
Applies to: Bar
Values: Selected non-aggregate columns
X-Axis/Y-Axis Select values to display as data in the pivot chart
Applies to: Grid Chart
Values: List of available columns
X Axis / Y Axis Labels Select label orientation.
Applies to: Bar
Values: Horizontal, 45 Deg or Vertical
Y-Axis Range This can be used to limit the range of the Y-Axis. The chart is cropped to fit into the defined range.
Applies to: Bar
Values: Yes/No. Min and max of range to be entered if Yes is selected.
Zoom Slider Display a zoom slider at the bottom of the chart.
Applies to: Bar, Line, Scatter, Area, Box Plot
Values: Yes/No

IN THIS PAGE