Any Metric or Table View can be displayed as a chart in Pigment, with chart values reflecting the data exactly as it appears in the grid. In this article, you will find examples of charts and chart configuration options.

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.

Customize 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 Lines
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. (on by default)
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 Line with dots Dots Flat lines
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
Balance data	The Balance data option adds an additional bar to represent any variation or contribution not fully explained by the displayed data. This ensures the total difference between start and finish values is accurately reflected.	Toggle on/off (off by default)
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, see Waterfall Charts.

Map Chart

A Map Chart with markers (L) and areas (R).

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.

Reporting and Data Visualization

Product

Use Cases

Resources

Company

Follow