Interactive Chart Tool

Interactive Chart Tool

Version:
Current
Last modified: March 16, 2020

Use the Interactive Chart tool to visualize data in your workflow. Create charts, for example, interactive and multi-layered bar charts, line graphs, scatter plots, pie charts, and more. You can use your dataset to calculate the sum, count, average, minimum, and maximum of your selected choosing. Output your results as different file types using the Render Tool.

Configure the Tool

Run the workflow, before you open the tool, to see a preview of your chart within the Interactive Chart tool. Add a layer—a level of data that can be stacked with additional information to enrich your chart further.

Create Chart

A chart can include one or more layers of data. Add a title, legend, notes, and hover text for additional details.

The Interactive Chart tool in this image is displaying two layers of information at once; a bar chart and a line gvraph to distinguish the difference, and a legend to explain the two colors used for each graph.
Area

Area: A type of chart that displays a relationship of how data changes over time.

To create an Area chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Area.
  6. Select the Data for the columns to use as the values for the X and Y axes.
Bar

Bar: A type of chart that displays categorical data vertically and horizontally, with rectangular bars of heights or lengths proportional to the values they represent.

To create a Bar chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Bar.
  6. Under Orientation, select the Horizontal button.

Options

Labels:

To add labels to a bar chart:

  1. Create a bar chart.
  2. Navigate to Style > Layer submenu.
  3. Select a field to use for labels from the Text dropdown. It is recommended to select the Y axis.
  4. Make a selection from the Position dropdown to display the labels (it will default to None).
    • None: Do not display the labels.
    • Auto: Prefer to display labels inside the bar unless text does not fit—it will be displayed outside of the bar.
    • Inside: Always display labels inside of the bar.
    • Outside: Always display labels outside of the bar 

Constrain: An optional field that will manipulate label formatting to best remain tied to the bar on which it labels.

  • Inside: An attempt to manipulate the labels, to keep them within their corresponding bar. Commonly used with Position = Inside.
  • Outside: An attempt to manipulate the labels, to keep them no wider than the width of their corresponding bar. Commonly used with Position = Outside.
  • Both: An attempt to manipulate labels, to constrain Inside, if positioned Inside, and constrain Outside, if positioned Outside. Commonly used with Position = Both.
  • None: No attempt to manipulate or constrain labels. All will have the same formatting.

Stacked Bar: A type of chart that displays an extra level of detail within a simple bar chart, and allows you to see how subgroups of data contribute to the total. To create a Stacked Bar chart:

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Bar.
  6. Under Style > Layer, select Stack from Bar Mode.
  7. Under Orientation, select the Vertical or Horizontal button.
  8. Add a second layer, and repeat the process until satisfied with the layering results for your data.

Options

Use the Split functionality to create the additional layers.

Candlestick

Candlestick: A type of chart that displays the price movements of a financial asset for a specific period.

To create a Candlestick chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Candlestick.
  6. Select the Data for the columns to use as the values for the X, Open, High, Low, and Close axes:
    • Open: The value for an opening price in the time period.
    • High: The value for a high price in the time period.
    • Low: The value for a low price in the time period.
    • Close: The value for a closing price in the time period.
Heatmap

Heatmap: A type of map in which data values are represented as colors.

To create a Heatmap chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Heatmap.
  6. Select the Data for the columns to use as the values for the X, Y, and Z axes (Z: Representing values for a color gradient, in sections of the heatmap).
Line

Line: A type of chart which displays information as a series of data points connected by straight line segments.

To create a Line chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Line.
  6. Select the Data for the columns to use as the values for the X and Y axes.
Pie

Pie: A type of chart that displays data as a circle (divided into slices) to represent a numeric proportion.

To create a pie chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Pie.
  6. Select the Data for the columns to use as the values for the Labels and Values axes.
Scatter

Scatter: A type of plot that displays values for at least two variables, showing the correlation between two numeric sets of data.

To create a Scatter chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Scatter.
  6. Select the Data for the columns to use as the values for the X and Y axes.

Options

Bubble chart: A variation of a scatter chart where data points are replaced with bubbles, with an additional dimension of the data represented in the size of the bubbles.

To create a Bubble chart...

  1. Run the workflow.
  2. Select Configure Chart in the tool configuration window.
  3. Under Create > Layer, select Add Layer.
  4. Add a Name to the layer.
  5. Under Type, select Scatter.
  6. Select columns to use as the values for the X and Y axes.
  7. Under Create > Transforms, select Split.
  8. Select the column to split the data on.
  9. Under Style > Layer, set the Size to Variable, and then select another column to change plotted size on. The tool will create bubbles scaled to the size of the value in the column you select.

Charting Options

Batch

Batching allows you to quickly create multiple charts from a single chart definition, eliminating the need to create individual charts.

Example

You want to show Sales by Product and to batch by Store ID. The batched charts will include a chart for each Store ID, showing the Sales by Product.

To Batch your chart select Batch from the side menu.

  • Under Batched Charts, select On or Off.
  • When On, Select Columns to Group By > Group BySelect Group from the dropdown.
  • Custom Title for Batched Charts: If On, type ‘$’ to use a group value in the title.
Perform an Aggregation

Aggregations can only be performed on the X or the Y values—not both.

  1. Select Configure Chart in the tool configuration window.
  2. Under Create > Layer, select Add Layer.
  3. Select chart Type.
  4. Select columns to use as the values for the X and Y axes. Select the X or Y axis > Select Add Calculation > Select Count (or one of the many other options).
Secondary Y-Axis

To create a Secondary Y-Axis, create an Area, Box, Candlestick, Scatter, Line, or Bar chart.

  1. Add a second layer via Create > Layer > Add Layer. This can be an Area, Box, Candlestick, Scatter or Line (not a bar) chart.
  2. Select the checkbox for Secondary Y-Axis, directly below the final field selection.
  3. To format the axis, navigate to Style Axis sub-menu, and select a new axis to make changes.
Split Data into Multiple Layers

Under Create > Transforms, select Split to separate data into multiple layers. Style each layer of a chart based on the number of different values within a column. 

The Transforms option is available for Area, Bar, Box, Line, and Scatter charts.

Add a title for each axis, adjust the range of values that display, and show grid lines and labels. The font for the axes titles and labels can be customized.

Style Options

Font

Select the global font, font size, and font color for the chart. Edits made to the font for the chart title, axes titles and labels, legend text, and notes will override these global font settings.

Layer

Select colors and show values when the cursor hovers over a data point on the chart. Many of the options depend on the type of chart selected.

Chart

Select the size, background color, margins and padding for the chart, and add a chart title.

Axes

Add a title for each axis, adjust the range of values that display, and show grid lines and labels. The font for the axes titles and labels can be customized.

Legend

Show a legend for the chart, and select the legend box font, color, and location. Select and drag the legend to move it to a new location on the chart. For a layer to show in the legend, it must be enabled under Style > Layer.

Under Style, Select to configure the Default Font, Layer, Chart, Axes, Legend.

Add a note and arrow to the chart. Click and drag the note to move it to a new location on the chart.

Notes

To add notes to your chart select the Note button and add new text in the Note Text field. Text can be added as Rich Text or LaTeX.

These options are available:

  • Font: Select from the dropdown.
  • Size Pixel: Select the size.
  • Color: Select the color from the palette.
  • Angle: Select from the up-and-down arrows to increase or decrease.
  • Arrow: Select Show or Hide.
  • Width Pixel: Select the size from the up-and-down arrows to increase or decrease.
  • Color: Select the color from the palette.

Select the "x" to close the Interactive Chart window, and return to the workflow.

Additional Information

The chart title, axes titles, legend text, and notes can be edited by clicking directly on the chart. Add a link to text by specifying a URL. Hover over the area at the top of the Interactive Chart window to view Zoom, Pan, Zoom In, Zoom Out, Reset Axes, Toggle Spike Lines, and Save as PNG options.

Save and Import Chart Template

Save a chart and all its settings as a template, which can be imported into an Insight tool or a different Interactive Chart tool in a workflow.

You will need the same field names flowing into the tool for the chart to render.

Save Chart as Template

  1. Under Create, select Template.
  2. Enter a Template Name.
  3. Select Save.

Import Saved Template

  1. Under Create, select Template.
  2. Select the name of the template.
  3. Select Import.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.