Any Metric or Table View can be displayed as a chart in Pigment. In this article, you will find examples of charts and chart configuration options.
Table of Contents
Accessing Chart Display Mode
Use the menu on the top left of a Metric of Table view to switch to Chart Display Mode. This will give you the option to see how a chart would look under its current configuration. You can use the Pivot functionality to change where dimensions are located on the different axis. Click Format to be able to make adjustments to the chart you will use and the options for each chart.
Accessing Chart Options
Once switching to Chart mode and Selecting Formatting, the side panel will appear. This is where you configure all visual aspects of the chart. Pigment currently offers 5 different chart types: Bar, Line, Pie, Combined and Waterfall. You can toggle back between the different chart options and you’ll notice the options are different for each chart. |
|
Caveat
Please note that switching from series to X-axis and Pages, is done by using the Pivot panel as you would do in grids. When the view is switched to Chart mode, all Filters, Sort, and Totals configurations are kept. Filters and Sort option will affect the Chart which is displayed, but Totals won't be displayed in the Chart.
Chart specific settings
Bar Chart
Bar charts are useful for showing comparisons between categories of data or comparing changes for multiple groups over the same period of time.
Setting | Description | Options |
Layout | The Layout setting configures how series are clustered visually on a chart. | Grouped: Series are clustered side-by-side.
Stacked: Series values are added on the Y-axis, so each consecutive series appears above the last one. Make sure the units of all series match. |
Bar direction | The Bar direction setting configures the bar direction.
| Vertical: bars of each series will be displayed vertically.
Horizontal: bars of each series will be displayed horizontally. |
Bar margin | The Bar margin setting controls the width of each individual bar. | Move the slider to the right to increase the thickness of the bars or left to reduce it. |
Show bar label | The Show bar label setting shows/hides the label inside each bar displaying the value of the bar. | Toggle on/off (on by default) When bars become too thin to display within the bar they will disappear unless Allow Label overlap is turned on. |
Bar label position | The Bar label position setting allows you to position the bar chart label at the top of the bar instead of the center in Grouped chart layouts. | Toggle on/off (on by default) |
Allow Label overlap | The Allow Label overlap setting shows/hides the label inside each bar displaying the value of the bar. This feature ensures labels are present even if the bars are too thin. | Toggle on/off (on by default) |
Show stack total | The Show stack total setting displays the total of a bar stack at the top of the bar in Stacked chart layouts. | Toggle on/off (off by default) |
X label orientation | The X label orientation setting configures the orientation of the X-axis labels. Longer labels automatically have wrapped text. To avoid label overlap, use the diagonal or vertical option. | Horizontal, vertical or diagonal. Diagonal labels are not supported when multiple dimensions are displayed in the axis at the same time. |
Color theme | The Color theme setting configures different presets of colors to represent each series. | Outside of your Workspace color Palette. Pigment support 9 presets; Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York, Summer sky. |
Series colors | The Series colors setting allows you to select the individual colors for Items within a Series. | Assign each Item its own individual color. Pigment remembers the order of your selection if you switch through different Color themes. For example, if you assign an Item the first color in a palette, it will remain the first color regardless of which theme you select. |
Show X gridline and Show Y gridline | The Show X gridline and Show Y gridline settings enable the appearance of gridlines extending from the X and Y-axis. | Toggle on/off (on by default) |
Hide Y axis | The Hide Y axis setting removes the Y axis from view. | Toggle on/off (on by default) |
Show legend | The Show legend setting shows/hides the Legend of the chart series. Use this option to display or hide the legend. | Toggle on/off (on by default) |
Legend position | The Legend position setting configures the position of the legend. | The legend can be set to 4 different positions: Bottom right (default), Top right, Bottom center, Top center. |
Line Chart
Setting | Description | Options |
Line Shape | The Line Shape setting configures the shape of the curve which connect or interpolate the series data points. | Linear: Displays straight line segments connecting points
Natural: Displays smooth curve connecting points
Basis: Displays smooth curve interpolating points |
Line width | The Line width setting configures the width of the curve.
| Slider from 0 to 10 (2 by default, use 0 to hide the curve) |
Y stacked values | The Y stacked values setting configures the position of each series. If the Y Staked Value option is enabled, Series values are added on the Y-axis, so each consecutive series appears above the last. Note: Make sure units of all series match. | Toggle on/off (off by default) |
Area | The Area setting fills the area under each curve. | Toggle on/off (off by default) |
Color Theme | The Color Theme option configures different presets of colors to represent each series. | Currently, Pigment support 8 presets (Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York). |
Show X gridline Show Y gridline | The Show gridline options will allow you toggle on and off the gridlines that are shown in the background of the chart. | Toggle on/off (on by default for Y and off for X) |
Y Scale | This option allows you to control the size of your Y axis. | Auto - will automatically scale Y axis based upon the max and min value from your grid. Fixed - allows for a manual input of the Max and Min values shown on the Y axis. |
Include 0 | When in Auto Y Scale mode, this option will resize the scale to include 0 as either the min or max value. | Toggle on/off (off by default) |
Point | The Point option configures how data points appear on the chart. Disable that option to hide data points. | Toggle on/off (on by default) |
Point labels | The Point labels option toggles the appearance of value labels for each data point on a chart. | Toggle on/off (off by default) |
X gridline and Y gridline | The X gridline and Y gridline options enable the appearance of gridlines extending from the X and Y-axis. | Toggle on/off (on by default) |
X Label orientation | The X Label orientation setting configures the orientation of the X-axis labels. Longer labels automatically have wrapped text. To avoid label overlap, use the diagonal or vertical option. | Horizontal, vertical or diagonal |
Legend | The Legend setting shows/hides the Legend of the chart series. Use this option to display or hide the legend. | Toggle on/off (on by default) |
Legend Position | The Legend Position setting configures the position of the legend. | The legend can be set to 4 different positions: Botton right, Top right, Bottom center, Top center. (Bottom right by default) |
Combined Chart
Setting | Description | Options |
Series | Use Series to configure which items should be displayed as bars or lines. Items available in Series are the ones displayed as Rows in the Configure Panel. | Bars |
Stacked values | The Stacked values setting configures how series are clustered visually on a chart. | Toggle on : Series are clustered side-by-side. Toggle off : Series values are added on the Y-axis, so each consecutive series appears above the last one. Make sure units of all series match. |
Show Label | The Bar/Line Label setting shows/hides the label inside each bar/line displaying the value of the bar/line. | Toggle on/off (on by default) |
Bar label position | The Bar label position setting allows you to position the bar chart label at the top of the bar instead of the center in Grouped chart layouts. | Toggle on/off (on by default) |
Line Settings Display | The Display settings configures how line items are visualised. | Line without dots |
Secondary axis | The Secondary axis option allow you to plot line items on a secondary axis | Toggle on/off (off by default) |
Color Theme | The Color Theme option configures different preset of colors to represent each series. | Currently, Pigment support 8 presets (Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York). |
X gridline and Y gridline | The X gridline and Y gridline options enable the appearance of gridlines extending from the X and Y-axis. | Toggle on/off (on by default) |
X label orientation | The X label orientation setting configures the orientation of the X-axis labels. Longer labels automatically have wrapped text. To avoid label overlap, use the diagonal or vertical option. | Horizontal, vertical or diagonal |
Legend | The Legend setting shows/hides the Legend of the chart series. Use this option to display or hide the legend. | Toggle on/off (on by default) |
Legend Position | The Legend Position setting configures the position of the legend. | The legend can be set to 4 different positions: Botton right, Top right, Bottom center, Top center. (Bottom right by default) |
Pie Chart
Setting | Description | Options |
Inner Radius | The Inner Radius option configures the radius for the "donut hole". | Slider 0 to 95 (50 by default, by setting this option to 0, the chart will be displayed as a Pie chart instead of a donut) |
Color Theme | The Color Theme option configures different preset of colors to represent each series. | Currently, Pigment support 8 presets (Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York). |
Radius Label | The Radius Label option toggles the appearance of labels outside of each slice displaying the series name. | Toggle on/off (on by default) |
Slices Label | The Slices Label option toggles the appearance of a label inside each slice displaying the value of the slice. | Toggle on/off (on by default) |
Corners | The Corners option configures the corner radius of each slice of the pie chart. | Slider 0 to 100 (0 by default) |
Legend | The Legend setting shows/hides the Legend of the chart series. Use this option to display or hide the legend. | Toggle on/off (on by default) |
Legend Position | The Legend Position setting configures the position of the legend. | The legend can be set to 4 different positions: Botton right, Top right, Bottom center, Top center. (Bottom right by default) |
Waterfall Chart
Setting | Description | Options |
Padding | The padding allows you to play with the spacing between bars |
From 0 to 0.9 |
Auto scaling | By default, Y-axis starts at 0. If activated, the scale will be inferred from the underlying data. | Toggle on/off (on by default) |
Connecting lines | The connecting lines option allows you to add dashed lines between the bars | Toggle on/off (on by default) |
Hide zeros | The hide zeros toggle allows you to hide the bars with a value of 0. | Toggle on/off (on by default) |
X Label orientation | The X label orientation setting configures the orientation of the X-axis labels. Longer labels automatically have wrapped text. To avoid label overlap, use the diagonal or vertical option | Horizontal, vertical or diagonal |
Allow horizontal scroll | The Allow horizontal scroll setting allows you to toggle on and off horizontal scrolling along the x-axis. | Toggle on/off (on by default) |
Step color | Choose the color of your step | Color picker (grey by default) |
Ascending values color | Choose the color of your ascending values | Color picker (green by default) |
Descending values color | Choose the color of your descending values | Color picker (red by default) |
For more information on waterfall charts, check out this article dedicated to them!
Map Chart
A Map chart allows you to visualize data geographically to make informed decisions and easily optimize your strategy. For more information, see How to Set Up a Map Chart.
Org Chart
The Org Chart displays hierarchical relationship between items. The main use case for an Org Chart is to visualize the structure of an organization. For more information, see How to Set Up an Org Chart.
See also: