Charts

What is a Chart?

Charts are essential data visualization tools in Squirrel. A chart, also known as a graph, is used to quickly and effectively present the relationship between two or more sets of data that the audience can easily understand and remember. They have numerous uses, as many businesses rely on data to assess priorities and formulate strategies. Examples of chart usage include evaluating overall sales and expenses over a period of time, as well as more specific instances like monitoring orders fulfilled per hour by a service at a specific location. In addition to simplifying large and complex sets of data, charts can be customized and visually enhanced to make the data more understandable. Using design elements such as axis banding, coloured categories, or even font size can impact the viewer's perception of the data.

Learn more about...

Area Chart

Bar Chart

Chord Diagram

Column Chart

Combination Chart

Line Chart

Pie Chart

Sankey Diagram

Schedule (Gantt)

Spline Chart

Step Chart

Plotting Data on a Chart

There are 2 ways to plot data into a Chart component:

1. Bind to datablock

2. Bind individual series

Binding to datablock

To bind to a data block, your spreadsheet data must be in a single block format. It should look something like this:

To ensure that the Chart component is set to Bind to datablock, look at the DATA section of the Chart component properties panel and ensure that the 'Bind to datablock' radio option is selected:

Bind this datablock to the Chart under the DATA section of the properties panel. After confirming the selection in the spreadsheet, the chart will populate with the selected data.

Bind individual series

When binding to individual series, you can bind to single sets of data in multiple areas of the spreadsheet without the need to bind to a data block first.

The layout of the data can be changed by clicking the Switch data layout button to change the data orientation.