Chart Settings Reference
Each chart type can be customized using the available settings. Click the 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 |