. Important note on my add-onsI've (reluctantly) decided to stop supporting all my Apps Script add-ons, as I no longer have the time or inclination to put them through the various verification processes and upcoming add-on store process changes.
Introductory videoHere's a video showing the features of Chord Snip On startingHere's the Add-on launching menu item On initialization, Chord Snip automatically identifies the data on the active sheet and builds a Chord diagram. The sidebar looks like this and shows a preview of the chart you can choose to insert into your sheet. About Chord diagramsActually you'll see the explanation below in the About tab
What is a Chord diagram?A chord diagram is a visualization of the relationship between data items, usually showing the flow of data between items in a system. The diagram is arranged as connected chords in a circle and can show flows in both directions. Chord Snip is a Google Sheets add-on/Office add-in which maintains a chord diagram preview in the sidebar of the active sheet's data in real time.Suitable types of dataChord charts are often used to show flows between places or members of a system (for example journeys to and from places)Data formatA Chord diagram needs 3 data items, which should be laid out as columns with headers in a sheet.
Chart imageYou can get a scaled up version of the chart preview by copying the code shown in the Chart settings/embed code area. This will be in SVG format so that you can embed the code or link to the drive file in a web site or document.
Source data columnsThere are 3 columns of interest for a Chord diagram. Chord snip will try to deduce which columns are which, but you can explicitly set them via the Data settings dialog. The columns section can be used to modify the source data location. By default all the data in the active sheet is incorporated into the chart. If you select and area of data, and choose selected range from the source data section, the chart will only use data from the selected area.
Test dataIf Chord snip detects that there is no suitable data on the current page, you'll get a message like this, and it will even generate a new sheet with some data to play around with if you want. Inserting a full sized chart in the sheet.To embed a chart image in your sheet, select a cell that at which the top left corner of the chart should be positioned, and use Insert.
Removing an inserted imageYou can manipulate or remove an already inserted image from your sheet with this standard sheets image dialog. Chart settingsThere are a large number of settings available to change the appearance of both the preview and full sized chart. Let's take a look through them. It should be evident from the images what each setting does. This dialog gives access to further settings to change the appearance of various attributes of the chart. Link appearanceThese settings set the appearance of the links between each node.
Color modesThese identify the color scheme approach. There are various to choose from which may be extended over time. These schemes are used to color both the nodes and the links. Ramp position and ramp value will create a color ramp scheme which will be interpolated using either the position of the node, or its total volume to scale the color. The start and finish ramp colors can be specified OpacityOpacity is a value beteen 0 and 1 and is the transparency of the color. A lowish value is most effective for this kind of diagram so the crossovers can be more clearly seen. Here's what an opacity of 1 looks like, using the google20 scheme. Here's the same diagram with the border width set to 0. Node appearanceThe nodes are the chords round the exterior of the circle. They take their fill colors from the link color schemes and opacity.
TooltipsHovering over a link or a node will reveal some data. The tooltip format is not configurable. InteractivityThe preview diagram is interactive. Hovering over a node will hide all but its links Images embedded in sheets don't have this interactivity, since the are simply images of a diagram.
|
Managing settings
Save settings
Reset settings
In an open document, you can select some different setting by using the Apply settings dialog
Data Settings
Respecting Filters
Availability
Pro version
All features mentioned here are available in the current Chord Snip version. At some future time, there might be a pro-version with additional capabilities, or a lite version with some features that might need to be unlocked before they are available. For more information on this join our community