Skip to main content

Plot

Plot helps you explore your data by creating charts and graphs to illustrate trends and highlight key findings. Plot can create a wide variety of graphs, charts, maps, and matrices, including:

  • Bar charts
  • Box plots
  • Bubble charts
  • Correlation matrices
  • Donut charts
  • Geomaps
  • Heat maps
  • Histograms
  • Horizontal bar charts
  • Hybrid charts (bar-line, scatter-line, and bubble-line charts)
  • Line charts
  • Parallel coordinates charts
  • Ridgeline charts
  • Scatter charts
  • Stacked area charts
  • Stacked bar charts
  • Sunbursts
  • Tree maps
  • Violin charts

Format​

Plot has a different format for each available graph, chart, map, and matrix. Note that any piece of the format below in parentheses is optional:

  • Plot a bar chart with x-axis <x_column>, y-axis <y_columns>(, for each <partition column>, with overlay <overlay column>, and sliding by <sliding column>/create subplots from <subplot column>, high-error-bar <upper bound column> low-error-bar <lower bound column>)
  • Plot a boxplot with x-axis <x_columns>, y-axis <y_column>, and sliding by <sliding column>/create subplots from <subplot column>
  • Plot a bubble chart with x-axis <x_column> y-axis <y_column> bubble color <color column> bubble size <size column> and sliding by <sliding column>/create subplots from <subplot column>, and label using <label column>
  • Plot a correlation matrix <using/excluding> <using/excluding columns>. Correlation matrices can use a maximum of 56 columns.
  • Plot a donut chart split by <donut split column> (for each <partition columns> | sized by <donut size column> | and sliding by <sliding column>) A donut chart displays up to 500 unique slices. Beyond 500, 100 unique slices are displayed, and the rest consolidated into an "Other" slice.
  • Plot a geomap with <location type> outlines for each <location column>, value <value column>, and sliding by <sliding column>
  • Plot a geomap with latitude <latitude column>, longitude <longitude column> (, heatmap density <heatmap density column>, and sliding by <sliding column>, bubble color <color column> bubble size <size column>)
  • Plot a heat map of the column <density column> with the x-axis <x_column>, the y-axis <y_column>, and sliding by <sliding column>/create subplots from <subplot column>
  • Plot a histogram with the x-axis <primary column> and sliding by <sliding column>/create subplots from <subplot column>
  • Plot a horizontal bar chart with x-axis <x_columns> y-axis <y_column>, and create subplots from <subplot column>
  • Plot a hybrid bar-line chart with x-axis <x_columns>, the bar-y-axis <primary y column>, the line-y-axis <secondary y column> (for each <partition column>, and sliding by <sliding column>/create subplots from <subplot column>)
  • Plot a hybrid bubble-line chart with x-axis <x_columns>, the bubble-y-axis <primary y column>, the bubble size <size column>, the line-y-axis <secondary y column> (for each <partition column>, and sliding by <sliding column>/create subplots from <subplot column>)
  • Plot a hybrid scatter-line chart with x-axis <x_columns>, the scatter-y-axis <primary y column>, the line-y-axis <secondary y column> (for each <partition column>, and sliding by <sliding column>/create subplots from <subplot column>)
  • Plot a line chart with the x-axis <x_column>, the y-axis <y_columns>, (for each <partition column>, <with smoothing>, and sliding by <sliding column>/create subplots from <subplot column>, and label using <label column>)
  • Plot a parallel coordinates chart for the column <x_columns>, color using the column <color column>, and slide by <sliding column>
  • Plot a ridgeline chart with the x-axis <x_column>, the y-axis <y_column>, (and sliding by <sliding column> | create subplots from <subplot column> | split by <split column>)
  • Plot a scatter chart with the x-axis <x_column>, the y-axis <y_column>, (for each <partition columns>, and sliding by <sliding column>/create subplots from <subplot column>, and label using <label column>)
  • Plot a stacked area chart with the x-axis <x_column>, the y-axis <y_columns>, and sliding by <sliding column>/create subplots from <subplot column>
  • Plot a sunburst of <numeric column> for each of the columns <hierarchical columns>
  • Plot a treemap of <numeric column> for each <hierarchical columns>
  • Plot a violin chart with the x-axis <x_column>, the y-axis <y_columns>, split by <split column> and sliding by <sliding column>/create subplots from <subplot column>

Parameters​

The main parameters of this skill are:

  • type (optional). For bar and area charts, the options are stacked, overlayed, or partitioned.
  • x_column (required). The column whose values to use as the x-axis. In bar, bubble, and scatter charts, this can also be a column reference.
  • x_columns (required). A comma-separated list of columns whose values to use as the x-axis. A single column can be used.
  • y_column (required). The column whose values to use as the y-axis. In bar, bubble, and scatter charts, this can also be a column reference.
  • y_columns (required). A comma-separated list of columns whose values to use as the y-axis. A single column can be used. In bar charts, this can also be a column reference.
  • primary y column (required). In a hybrid chart, the column whose values to use as the y-axis for the bar chart.
  • secondary y column (required). In a hybrid chart, the column whose values to use as the y-axis for the line chart.
  • partition columns (optional). The column on whose values to partition the graph.
  • with smoothing (optional). For line charts, you can choose to use smooth, round lines to create a spline chart.
  • sliding/subplot column (optional). The column whose values to use as a sliding scale or to create subplots. Subplots show every possible chart in the same panel instead of using a slider to change the chart. Note that overlayed bar charts do not support subplots. Note that charts cannot have more than 16 subplots.
  • label column (optional). For bubble, line, and scatter charts, the values of this column are used to label each point in the chart.
  • model (required). For a confusion matrix, choose an existing classification model.
  • dataset (optional). For a confusion matrix, choose the dataset (with the same features as the dataset used to train the model you entered as the <model> parameter), to use for the matrix.
  • overlay column (optional). For a bar chart, the overlay column is used as a secondary y-axis and its values are overlaid on the bars of the primary y-axis.
  • upper bound column (optional). For bar charts, if your dataset contains values that act as the upper bound of a value, you can specify that column here (along with the lower bound column) to create an error bar overlay indicating the range between the upper and lower bounds.
  • lower bound column (optional). For bar charts, if your dataset contains values that act as the lower bound of a value, you can specify that column here (along with the upper bound column) to create an error bar overlay indicating the range between the upper and lower bounds.
  • color column (optional for bubble charts, required otherwise). For bubble charts and parallel coordinate charts, this column’s values are used to determine the color of each bubble.
  • target column name (required). For confusion matrices, this is the original column whose values you're trying to predict and compare against.
  • predicted column name (required). For confusion matrices, this is the new column created by your machine learning model that should be compared against the values of the target column.
  • donut size column (optional). The column values, grouped by the required Split column, to use to create the chart's slices. If this field is empty, the entire dataset is used and grouped by the required Split column.
  • size column (required). For a bubble chart (and hybrid bubble-line charts), this column’s values are used to determine the size of each bubble.
  • using/excluding (required). For a correlation matrix, specify whether you want to include or exclude the specified columns.
  • using/excluding Columns (required). For a correlation matrix, the columns to include or exclude.
  • donut split column (required). The column whose values populate the donut chart.
  • split column (optional). For violin charts, this column’s values are used to group the chart into sections. This column must contain exactly two distinct values, such as “True” and “False” or 1 and 0. Using a split column overrides the chart’s default grouping.
  • density column (required). For geomaps, heatmaps, and histograms, this column’s values are used as the plot points.
  • location type (required). For geomaps, this is the type of outline you want to use. The options include:
    • Country
    • County FIPS
    • Latitude
    • State
    • ZIP code
  • location column (required). For geomaps, the column that contains the location data.
  • value column (required). For geomaps, this column’s values are used to populate the map.
  • latitude column (required). For geomaps, this column’s values are used as the latitude coordinates.
  • longitude column (required). For geomaps, this column’s values are used as the longitude values.
  • numeric column (required). For sunbursts and treemaps, this column’s values are aggregated and then split among the hierarchical columns.
  • hierarchical columns (required). For sunbursts and treemaps, these columns are used as categories to group the values of the numeric column.

Output​

If the chart, graph, map, or matrix is successfully created, it’s shown in the Data tab and a success message is shown in the conversation history.

If the chart, graph, map, or matrix can’t be created, an error message is shown.

Examples​

Consider a dataset called “Titanic” that contains information on each passenger, including the following columns:

  • Age. Their age.
  • Gender. Their gender.
  • Name. Their name.
  • PClass. Their class.
  • Survived. Whether they survived the disaster.

A bubble chart could help visualize how a passenger’s class, gender, and fare price influenced whether or not they survived. To create this chart, enter Plot a bubble chart with the x-axis Pclass, the y-axis Age, the bubble color Survived, the bubble size Fare.

Feedback