Plot options chart
This menu can be accessed by clicking the gear in the upper right corner of the visualization tab. Some of the options listed below may be grayed out or hidden in situations where they would conflict with other settings you have chosen. The following options are available. Not all options apply to all chart types. Grouped: For column and bar charts.
Series are clustered side-by-side. Overlay: For scatterplot, line, and area charts. Series are overlayed on the chart.
Stacked: Series values are added on the y-axis, so each consecutive series appears above the last. Be sure that the units of all series match.
Grid Layout Grid Layout provides options to separate, or trellis, a chart into several smaller charts, each representing a single row or pivot from the results table. You can separate a chart into a maximum of 12 smaller charts.
PlotOptions (Vaadin Charts Addon beta1 API)
You can input a number between 1 and If you do not input a number, Looker will arrange the charts as evenly as possible. When used with the new dashboard experiencegrid layout becomes responsive to the dashboard tile size and shape, as long as Number of Charts per Row is not set. When toggled on, null values are plotted at zero. When toggled off, sections of line and area charts may show gaps. This parameter is only available when Series Positioning is Overlay.
Swap X and Y Swap X and Y toggles whether the x and y axes are swapped from the normal configuration. When swapped, dimensions will be plotted on the y-axis, and measures will be plotted on the x-axis. Hide Legend Hide Legend toggles the appearance of the series legend on a chart.
This is only available when there is more than one series except in the case of a pie chart. Legend Align Legend Align specifies whether the series legend will appear to the left, center, or right of the chart. This is only available when Hide Legend is off, and when there is more than one series. Limit Displayed Rows Limit Displayed Rows enables you to show or hide rows in a visualization, based on their position in the results.
For example, if your visualization was displaying a 7-day rolling average, you may want to hide the first 6 rows. Click Limit Displayed Rows to enable or disable this feature.
Once enabled, you can specify the following indicators in options Hide or Show: Choose Hide to exclude certain rows from the visualization. Choose Show to display only a limited number of rows in the visualization.
First or Last: Choose if the rows to be plot options chart or shown will be the first or last rows in the result set. Number: Specify the number of rows to be hidden or shown. In the Data section below your visualization, any excluded rows will be shown in a darker color, and will be marked with a symbol to the left of the row number: This option is dependent on the row order, so changing the query's sort order or adding a row limit can change the rows that plot options plot options chart shown or hidden in the visualization.
Series Menu Options The series menu controls how your chart shows each data series. Colors You can define the color palette for a chart plot options chart the Colors section. Collection Choose a color collection from the Collection drop-down menu. A collection allows you to create themed visualizations and dashboards that look good together. You can see all the palettes in each of Looker's built-in color collections on the Color collections documentation page. Your Looker admin may also create a custom color collection for your organization.
Once you select the color collection, the Palette section will update with a palette from that collection.
Plot Options for Trend Charts
plot options chart Palette Once you've selected a color collection, you can choose a different palette from the collection, or customize your palette, by clicking the color palette itself. This plot options chart the palette picker and displays all the palettes from the collection. Plot options chart are assigned to each series in order. For a categorical palettethe first color in the palette is assigned to the first series, and so on.
For a sequential or diverging palettethe color at the left end of the palette is assigned to the first series and the colors for each remaining series move to the right on the palette. If your query returns more data series than colors listed, the colors repeat from the beginning of the palette, first as a lighter version of each color, then as a darker version of each color.
Creating a Custom Color Palette To create a custom color palette, first select the Custom tab on the palette picker. You can edit your palette in several ways: Click on one of the colors present to edit it.
Subscribe to RSS
To change a selected color, or edit all colors at once, you can input hex stringssuch as 2ca6cd, or CSS color namessuch as mediumblue, into the color value box at the bottom of the picker. You can also click the color wheel to the right of the color value box to bring up a color picker, which can be used to select a color.
The corresponding hex value for that color appears in the color value box: If you click EDIT ALL, you'll see that the color value box is populated with the hex codes of the color palette you've chosen or customized. Copying and pasting this list is the best way to copy custom color palettes from one chart to another. Reverse Colors Select Reverse colors to reverse the palette.
Plot Menu Options
For a categorical palettethis would apply the last color in the palette to the first series, the second-to-last color in the palette to the second series, and so on. For a sequential or diverging palettethis would apply the color at the right end of the palette to the first series and move left on the palette for the remaining series. Show Full Field Name Show Full Field Name determines whether to show the view name along with the field name for each axis title and series name.
When Show Full Field Name is turned off, generally only the field name shows; however, measures of type count display only the view name instead. Point Style Point Style specifies how data points appear on the chart. The following options are available: None: For line and area charts. Points are not displayed. Circle filled : Filled circles are displayed.
Circle outline : Outlined circles are displayed. Size Points by Field Selecting a field in the Size Points by Field drop-down sizes all points on the chart by the selected field. That field will no longer be plotted separately on the chart, unless Plot Size-By Field is turned on. When points are sized by a field, a key appears in the legend indicating which field the points are sized by.
Size Points by Field is disabled when a data table contains a pivot and also contains a measure that falls outside of the pivot. This switch determines whether the field used to size the points is also plotted separately. When plot options chart is off, which is the default setting, the field is not plotted. When it is on, additional trading robots are profitable appear on the chart representing that field.
Customizations Each series in the chart can be customized in several different ways: Click the arrow next to a series to expand its options. Click on the plot options chart swatch to select a custom color for the series. This overrides the color palette defined by the Colors option. Enter a custom series label if desired. This impacts the chart legend and tooltips. Select a different visualization type for the series if desired. This is useful if you want to combine different visualization types on the same chart, such as showing one series as columns and another series as a line.
For line, area, or scatter series types, select the shape of the chart points.
Values Menu Options Value Labels toggles the appearance of value labels for each data point on a chart. Value Colors Value Colors defines the colors of the value labels. This field takes a comma-separated list of one or more color values.
If set to multiple colors, colors will be assigned to each series in order. The first series in the underlying table will be assigned the first color, and so on. If the query returns more data series than colors listed, Looker will assign the series color to the value label after it runs out of your custom colors. If no color values are provided, Looker assigns the series color to the value label.
Generally users will specify a number of pixels, such as 10px or 12px. Value Rotation Value Rotation sets the rotation of the value labels. This parameter accepts values between anddenoting the number of plot options chart to rotate the labels.
Value Format Value Format specifies the format of the value, independent of plot options chart underlying dimension or measure. The field accepts Excel-style formatting.
If no formatting is specified, the value will be displayed in the format of the underlying dimension or measure. Plot options chart can read Excel's complete guide about how to specify these formats in their documentation. However, color formatting is not currently supported in Looker. In the Value Format field, the formatting string is not enclosed in quotes. The Adding custom formatting to numeric fields documentation page provides more information on how to use custom formatting.
Automatic Based on Data: The scale will be inferred from the underlying data. This is the default setting. Ordinal: The data is plotted along the x-axis as evenly-spaced, discrete entries, regardless of relative distance between data points. Linear: The data is plotted as linear numeric values. This option only applies when the plot options chart data can be converted to numbers. Time: The data is plotted as time values.
The x-axis is labeled with appropriate time increments. Reverse Axis Reverse Axis toggles the direction of the x-axis. When this is off, values increase from left to right. When this is on, values decrease from left to right.
It accepts any string value. Gridlines Gridlines toggles the appearance of gridlines extending from the x-axis. Gridlines are spaced based on the scaling of the x-axis.
TC2000 Help Site
Label Rotation Label Rotation sets the rotation of the x-axis value labels. Time Label Format Time Label Format specifies how x-axis value labels are displayed for charts with a time dimension on the x-axis.
This parameter accepts time formatting syntax, as shown below. See Time Formatting for Looker Charts for all formatting options. Gridlines are spaced based on the scaling of the y-axis.
Reverse Axis Reverse Axis toggles the direction of the y-axis. When this is off, values increase going up the axis. When this is on, values decrease going up the axis.