Working with Chart Types

Bar

Horizontal

Stacked Horizontal

Vertical

Stacked Vertical

Bar graphs show categories as bars and quantities as bar lengths and are useful for comparing differences among like items. Bar graphs support drill-down functionality.

For a horizontal bar graph, you can select multiple X Axis values. For a vertical bar graph, you can select multiple Y Axis values. On an axis with multiple data values, a separate bar will represent each data value. The bars will be stacked on a stacked bar graph.

Bubble

Bubble graphs display data elements as circles or "bubbles". It shows four variables in two dimensions. One value is represented by the location of the circle on the horizontal axis. Another value is represented by the location of the circle on the vertical axis. The third value is represented by the radius of the circle. The fourth value is represented by the color of the circle. The color of the bubble is optional.

Bubble graphs are useful for plotting data with three or four variables, and for displaying financial data over a period of time.

Line

Line graphs are useful for visualizing trends or quantities over time.

Line Bar

Vertical

Stacked Vertical

Line-bar graphs plot two sets of data with different ranges: one set as bars, and one set as lines overlaid on the bars. This visual makes line-bar graphs useful for displaying relationship trends between data sets.

You can select multiple values to plot as lines on a line bar graph and a stacked line bar graph.

For a vertical line bar graph, you can select multiple Y Axis values to create separate bars that represent each data value. The bars will be stacked on a stacked vertical line bar graph.

Pie

Pie charts are useful for comparing parts of a whole, such as projects by manager or location within a workspace. Pie charts support drill-down functionality.

Pivot Table

Pivot tables display the aggregated data from rows and columns in a table. For example, you can use a pivot table to measure the number of tasks assigned to each company for every activity in a project. Aggregated values are totaled for each row and column. The row totals and column totals are combined into a Grand Total value.

Status Meter

Status meters measure data against predefined values. A gauge usually plots one data point with an indication of whether that point falls in a high, medium, or low range, making gauges useful for showing performance against goals.

Table

Tables display results organized by rows and columns. A table provides a summary view of data and enables users to see different views of data by arranging rows and columns.

Tree Map

Tree Maps display a space-constrained, two-dimensional visualization for hierarchical structures with multiple levels. Tree maps are limited by a predefined area and display two levels of data and contain rectangular tiles. The size of the tile is based on a measure, and the color of the tile is based on a second measure.