Choosing the right visualization

Visualizations

• Bar chart: Visualize differences in measures over one or more dimensions, arranged as a series of bars with varying height. Can be displayed in vertical or horizontal format, and with grouped, stacked, or butterfly presentation.

• Box plot: The box plot is suitable for comparing range and distribution for groups of numerical data, illustrated by a box with whiskers, and a center line in the middle.

• Bullet chart: Bullet charts can be used to visualize and compare performance of a measure to a target value and to a qualitative scale, such as poor, average, and good.

• Combo chart: The combo chart combines bars and lines in the same chart. The bars and lines have different axes to enable comparing percentages and sums. Available as horizontal or vertical combo chart.

• Distribution plot: The distribution plot is suitable for comparing range and distribution for groups of numerical data. Data is plotted as value points along an axis.

• Filter pane: The filter pane allows you to control what data that is shown in the visualizations on a sheet. A filter pane can filter the data of several dimensions at once.

• Funnel chart: A funnel chart is a visual representation of the connected stages of a linear process.

• Gauge: The gauge is used to display the value of a single measure, lacking dimensions.

• Grid chart: A chart that displays comparative data and with the values represented as colors.

• Histogram: The histogram is suitable for visualizing distribution of numerical data over a continuous interval, or a certain time period. The data is divided into bins.

• KPI: The KPI is used to present central performance figures. You can add a link to a sheet.

• Line chart: The line chart displays data lines between values. Line charts are often used to visualize a trend in data over intervals of time. Can also be presented as an Area line chart.

• Map: The map is used to combine geospatial data and measure values, such as the sales for a region or a store.

• Mekko chart: The mekko chart compares a group while comparing category items contained within these groups.

• Org chart: Creates an organization chart with a tree structure.

• Pie chart: The pie and donut charts show the relation between a single dimension and a single measure. Can also be presented as a Donut chart.

• Pivot: Pivot presents dimensions and measures as rows and columns of a pivot table. The pivot table allows you to analyze data in multiple dimensions at a time. The data in a pivot table may be grouped based on a combination of the dimensions, and partial sums can be shown.

• Pivot table: The pivot table presents dimensions and measures as rows and columns of a table. The pivot table allows you to analyze data in multiple dimensions at a time. The data in a pivot table may be grouped based on a combination of the dimensions, and partial sums can be shown. This pivot table has styling options not available to Pivot.

• Sankey chart: A flow chart diagram chart visually emphasizing major transfers or flows within defined system boundaries.

• Scatter plot: The scatter plot presents values from two measures. This is useful when you want to show data where each instance has two numbers, for example, country (population and population growth). An optional third measure can be used and is then reflected in the size of the bubbles. When showing large data sets colors will be used instead of bubble size to represent the measure size.

• Straight table: The straight table allows you to present tabular data for detailed analysis. You can apply pagination to simplify consumption of large data volumes. You can also allow users to add and remove columns temporarily during analysis, using an enhanced chart exploration experience.

• Treemap: The treemap shows hierarchical data. A treemap can show a large number of values simultaneously within a limited space.

• Waterfall chart: The waterfall chart illustrates how an initial value is affected by intermediate positive and negative values.

• Write table: Use the write table to allow users to make changes in editable columns during data analysis.

Dashboard objects

• Animator: You can animate changes in your visualizations over a period of time.

• Button: You can use buttons to add quick links for easy selection and navigation in your app.

• Date picker: You can select a single date or a range of dates from a calendar.
• Layout container: Add and arrange visualizations in a container.
• Line: Add vertical and horizontal lines to a sheet.

• Navigation menu: The navigation menu adds a sheet navigation options into your sheet.

• NL insights: The NL insights visualization displays natural language insights about data in the form of a chart.

• Tab container: You can add visualizations in a limited space and show or hide the visualizations inside the container based on conditions.

• Text: You can use the text visualization to add text and links to webpages.

• Trellis container: Creates a trellis chart based on a master visualization.

• Variable input: You can set the value of a variable.
• Video player: You can add a video to your sheet.

Legacy objects

• Funnel chart: A funnel chart is a visual representation of the connected stages of a linear process.

• Network chart: Creates a cluster diagram representing a graphical chart of a computer network.

• P&L pivot: Creates a pivot table that you can style, for example for profit and loss reporting.

• Radar chart: Creates a two-dimensional chart using radial axes to show the scoring of a measure in one dimension or another.

• Table: The table displays values in record form, so that each row of the table contains fields calculated using measures. Typically, a table includes one dimension and multiple measures. The Straight table has replaced the Table as the default table visualization.

• Text & image: You can use the text & image visualization to add text, images, measures and links to a webpage.

• Variance Waterfall: Shows the variance between two measures over the different values of a dimension.

• Word cloud: A cloud chart of words with their size based on measure value.