Design a View as a Chart

To help visualize a query's results for at-a-glance analysis or comparison, a view's Owner or Editor can set its data to appear as a chart.

Select the Chart Type

To represent a view as a graph, click Charts , and select the type of visualization to use.

Type	Data Visualization	Suggested Use
Column	Vertical bars, or columns	For comparisons, or to analyze variances or data with negative values.
Bar	Horizontal bars	For comparisons with long labels that might not render legibly under a vertical column , or to analyze a large number of datasets
Line	Points connected by a solid line	To represent continuous data or analyze trends, patterns, or large changes over time.
Scatter	Disconnected plotted points	To compare large numbers of data points regardless of time, or to analyze the relationship between variables; the closer plotted points are to forming a straight line, the stronger their relationship
Pie	A circular graph, with each data point as a separate segment, like pie slices	To analyze the components of a whole, or to compare categorical data
Bar Stack	Vertical bars, broken down by subcategories	To compare multiple types of data within a single bar, or to analyze part-to-whole relationships
Bar Line	A column chart with an overlapping line chart	To represent or analyze the relationship between different type of dependencies

You can set up how data should appear in the chart.

1: Click Format , and select Format Cells ; or click Column Formats on the right panel.
2: In Choose Column, select the data to format.
3: In Column Type, select whether to display the data' values as a string, number, date string, or timestamp.
4: In Text Align, select whether to align the data's values to the left or right.
5: In Thousand Separator, select the separator to use with amounts in the thousands, such as a comma, period, or none.
6: In Null Value, enter the text to appear when a value is empty. To not display any text, leave blank.
7: For number data, specify how to display its amounts.

In Decimal Separator, select whether to separate the integer and fractional parts of the number with a period or comma.
In Max Decimal Spaces, enter how many digits to display for the fractional part of the number.
In Currency Symbol, enter the symbol to use with monetary amounts, such as $.
Select whether to format the number as a percent.

To help ease understanding or highlight special circumstances, you can set conditional formatting for values in the chart.

1: Click Format , and select Conditional Formatting .
2: To add a new format, click Add (+).
3: For Value, select whether to apply the format to all values or only a specific value, and when to apply the format, such as "Less than 0" or "Empty".
4: For Format, select the font type, size, and color to display values as with the format applied.
5: Click Apply.