Interactive Chart Tool
The Interactive Chart tool creates interactive bar charts, line graphs, scatter plots, and pie charts for visualizing data in your workflow. The chart generated by the tool can be added to a report using the Visual Layout Tool, output as different file types using the Render Tool, or published as a dashboard using the Insight Tool.
Configure the tool
Run the workflow to read the data into the Interactive Chart tool, and then click Configure Chart to open the configuration window. A chart can include one or more layers of data, a title, a legend, notes, and hover text..
- Run the workflow.
- Click Configure Chart.
- Under Create > Layer, click Add Layer.
- Type a Name for the layer.
- Select the chart Type.
- Area: Displays a relationship of how data changes over time.
- Bar: Displays categorical data with rectangular bars of heights or lengths proportional to the values they represent.
- Box and Whisker: Displays groups of numerical data distributed by their quartiles.
- Candlestick: Displays the price movements of a financial asset for a specific period.
- Heatmap: Displays a map in which data values are represented as colors.
- Line: Displays information as a series of data points connected by straight line segments.
- Scatter: Displays values that show the correlation between two numerical sets of data.
- Pie: Displays data as a circle divided into slices to represent a numerical proportion.
- Select columns to use as the values for the X and Y axes.
- Under Style, click to configure the Default Font, Layer, Chart, Axes, Legend, and Notes:
- Default Font: Select the default 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 the default font.
- 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. Click 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.
- Note: Add a note and arrow to the chart. Click and drag the note to move it to a new location on the chart.
- Click 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, Show Axes Lines, and Save as PNG options.
Save a chart and all settings as a template, which can be imported into an Insight tool or a different Interactive Chart tool in a workflow.
To save a chart as a template:
- Under Create, click Template.
- Type a Template Name.
- Click Save.
To import a saved template:
- Under Create, click Template.
- Click the name of the template.
- Click Import.
Once you have created a single chart, you can batch it and output a set of charts. Select the data to group by to create a separate chart for each group of data.
To create a batched chart:
- Create a chart.
- Under Batch, click Batch.
- Click On.
- In Group By, select a column to group the data.
- To create a custom title for the batched chart, type in the title editor.
- View each chart by clicking the page numbers at the top.