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.
Selecting 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.
- Click Format , and select Format Cells ; or click Column Formats on the right panel.
- In Choose Column, select the data to format.
- In Column Type, select whether to display the data' values as a string, number, date string, or timestamp.
- In Text Align, select whether to align the data's values to the left or right.
- In Thousand Separator, select the separator to use with amounts in the thousands, such as a comma, period, or none.
- In Null Value, enter the text to appear when a value is empty. To not display any text, leave blank.
- 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.
- Click Apply.
To help ease understanding or highlight special circumstances, you can set conditional formatting for values in the chart.
- Click Format , and select Conditional Formatting .
- To add a new format, click Add (+).
- 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".
- For Format, select the font type, size, and color to display values as with the format applied.
- Click Apply.