Pigment reporting charts let you visualize data to better understand trends, comparisons, and key drivers. In Pigment, you can switch a View to Chart Display Mode, choose from different chart types, and configure how your data is displayed with formatting options.
Access Chart display mode
To access Chart Display Mode:
Use the menu on the top left of a Metric or Table View to switch to Chart Display mode and see how the current configuration would look in different chart formats.
You can use the Pivot functionality to change where Dimensions are located on the different axes. Select Format to make adjustments and see options for each chart.
Access chart display mode through the Format panel
Access Chart options
To configure all visual aspects of the chart:
Select Chart, then Format.
The Chart Settings panel appears.
Pigment currently offers seven different chart types: Bar, Line, Pie, Combined, Waterfall, Map, and Org chart. You can toggle between the different chart options to view the formatting options available for each chart.
.png?sv=2022-11-02&spr=https&st=2026-05-26T11%3A04%3A52Z&se=2026-05-26T11%3A25%3A52Z&sr=c&sp=r&sig=Rm%2FdYPfhdCaYsQcwz8hoHp%2BnTPC8B1rIW2PJiKZSDn8%3D)
Access chart options through the Format panel
ℹ️ Note
Switch from series to X axis and Pages using the Pivot panel as you would do in grids. When you switch View to Chart mode, all Filters, Sort, and Totals configurations persist. Filters and Sort affect the Chart displayed, but Totals are not displayed.
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.
Bar chart formatting panel
Setting | Description | Options |
Layout | 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 | Configures the bar direction. | Vertical: bars of each series are displayed vertically. Horizontal: bars of each series are displayed horizontally. |
Bar margin | 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 label | 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 chart they disappear unless Allow Label overlap is turned on. |
Bar label position | Allows you to position the Bar chart label at the top of the instead of the center in Grouped chart layouts. | Toggle on/off (on by default) |
Allow Label overlap | 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 | 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 | 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 by Theme | Configures different presets of colors to represent each series. | Outside of your Workspace Color Palette, Pigment supports nine presets: Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York, and Summer Sky. To use a Pigment theme:
To customize your Workspace palette or add additional colors for use in themes:
|
Color by Dimension Items | Applies the colors defined on each Dimension in the data model to represent each series. | To color your chart series by Dimension Items:
|
Customize colors | Allows you to select the individual colors for Items within a Series. | Select Edit chart colors to 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 remains the first color regardless of which theme you select. |
Show X gridline and Show Y gridline | Enables the appearance of gridlines extending from the X and Y axes. | Toggle on/off (on by default) |
Hide Y axis | Removes the Y axis from View. | Toggle on/off (on by default) |
Show legend | 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 | Configures the position of the legend. | The legend can be set to four different positions: Bottom right (default), Top right, Bottom center, Top center. It is scrollable for longer lists. |
Line chart
.png?sv=2022-11-02&spr=https&st=2026-05-26T11%3A04%3A52Z&se=2026-05-26T11%3A25%3A52Z&sr=c&sp=r&sig=Rm%2FdYPfhdCaYsQcwz8hoHp%2BnTPC8B1rIW2PJiKZSDn8%3D)
Line chart formatting panel
Setting | Description | Options |
Display | Configures the type of line that is used. | Line: Displays line that runs through the data points Line with dots: Displays line connecting dots on the data points Dots: Displays dots on each data point with no line connecting |
Line Shape | 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 | Configures the width of the line. | Slider from 0 to 10 (2 by default, use 0 to hide the curve) |
Dashed Lines | Controls whether a line is solid or dashed when lines are enabled in the Display setting. | Toggle on/off (off by default) |
Y stacked values | Configures the position of each series. If the Y stacked values option is enabled, series values are added on the Y axis, so each consecutive series appears above the last with their value added to the previous number. Make sure the units of all series match to ensure the desired result | Toggle on/off (off by default) |
Area | Fills the area under each curve. | Toggle on/off (off by default) |
Area opacity | Controls how transparent or solid the area is under the lines. | Slider from 0.5 to 1 (.2 by default, 1 is a solid area) |
Point labels | Toggles the appearance of value labels for each data point on a chart. | Toggle on/off (off by default) |
Allow Label overlap | Shows/hides the label on each data point displaying the value of the point. This feature ensures labels are present even if the data points are too close together. | Toggle on/off (on by default) |
X label orientation | Configures the orientation of the X axis labels. Longer labels automatically have wrapped text. | Horizontal, vertical or diagonal To avoid label overlap, use the diagonal or vertical option. |
Color by Theme | Configures different presets of colors to represent each series. | Outside of your Workspace Color Palette, Pigment supports nine presets: Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York, and Summer Sky. To use a Pigment theme:
To customize your Workspace palette or add additional colors for use in themes:
|
Color by Dimension Items | Applies the colors defined on each Dimension in the data model to represent each series. | To color your chart series by Dimension Items:
|
Customize colors | Allows you to select the individual colors for Items within a Series. | Select Edit chart colors to 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 remains the first color regardless of which theme you select. |
Show X gridline Show Y gridline | Allows you to 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) |
Combined chart
.png?sv=2022-11-02&spr=https&st=2026-05-26T11%3A04%3A52Z&se=2026-05-26T11%3A25%3A52Z&sr=c&sp=r&sig=Rm%2FdYPfhdCaYsQcwz8hoHp%2BnTPC8B1rIW2PJiKZSDn8%3D)
Combined line chart formatting panel
Setting | Description | Options |
Series | Configures 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 | 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 | Shows/hides the label inside each bar/line displaying the value of the bar/line. | Toggle on/off (on by default) |
Bar label position | Allows you to position the Bar chart label at the top of the instead of the center in Grouped chart layouts. | Toggle on/off (on by default) |
Line Settings Display | Configures how line Items are visualized. | Line without dots |
Secondary axis | Allows you to plot line items on a secondary axis | Toggle on/off (off by default) |
Color by Theme | Configures different presets of colors to represent each series. | Outside of your Workspace Color Palette, Pigment supports nine presets: Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York, and Summer Sky. To use a Pigment theme:
To customize your Workspace palette or add additional colors for use in themes:
|
Color by Dimension Items | Applies the colors defined on each Dimension in the data model to represent each series. | To color your chart series by Dimension Items:
|
Customize colors | Allows you to select the individual colors for Items within a Series. | Select Edit chart colors to 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 remains the first color regardless of which theme you select. |
X gridline and Y gridline | Enables the appearance of gridlines extending from the X and Y axes. | Toggle on/off (on by default) |
X label orientation | 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 | 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 | Configures the position of the legend. | The legend can be set to four different positions: Bottom right (default), Top right, Bottom center, Top center. It is scrollable for longer lists. |
Pie chart
.png?sv=2022-11-02&spr=https&st=2026-05-26T11%3A04%3A52Z&se=2026-05-26T11%3A25%3A52Z&sr=c&sp=r&sig=Rm%2FdYPfhdCaYsQcwz8hoHp%2BnTPC8B1rIW2PJiKZSDn8%3D)
Pie chart formatting panel
Setting | Description | Options |
Inner Radius | Configures the radius for the "doughnut 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 doughnut) |
Color Theme | Configures different preset of colors to represent each series. | Currently, Pigment supports eight presets: Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York. |
Radius Label | Toggles the appearance of labels outside each slice displaying the series name. | Toggle on/off (on by default) |
Slices Label | Toggles the appearance of a label inside each slice displaying the value of the slice. | Toggle on/off (on by default) |
Corners | Configures the corner radius of each slice of the pie chart. | Slider 0 to 100 (0 by default) |
Color by Theme | Configures different presets of colors to represent each series. | Outside of your Workspace Color Palette, Pigment supports nine presets: Pigment, Rainbow Spectrum, Copenhagen Facades, Sunset Boulevard, Winter Wonderland, Utility, Moreno Glacier, Autumn in New York, and Summer Sky. To use a Pigment theme:
To customize your Workspace palette or add additional colors for use in themes:
|
Color by Dimension Items | Applies the colors defined on each Dimension in the data model to represent each series. | To color your chart series by Dimension Items:
|
Customize colors | Allows you to select the individual colors for Items within a Series. | Select Edit chart colors to 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 remains the first color regardless of which theme you select. |
Legend | 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 | Configures the position of the legend. | The legend can be set to four different positions: Bottom right (default), Top right, Bottom center, Top center. It is scrollable for longer lists. |
Waterfall chart
(1).png?sv=2022-11-02&spr=https&st=2026-05-26T11%3A04%3A52Z&se=2026-05-26T11%3A25%3A52Z&sr=c&sp=r&sig=Rm%2FdYPfhdCaYsQcwz8hoHp%2BnTPC8B1rIW2PJiKZSDn8%3D)
Waterfall chart formatting panel
Setting | Description | Options |
Balance data | 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 | 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 | Allows you to add dashed lines between the bars. | Toggle on/off (on by default) |
Hide zeros | Allows you to hide the bars with a value of 0. | Toggle on/off (on by default) |
X Label orientation | 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 | Allows you to toggle on and off horizontal scrolling along the X axis. | Toggle on/off (on by default) |
Step color | Chooses the color of your step. | Color picker (grey by default) |
Ascending values color | Chooses the color of your ascending values. | Color picker (green by default) |
Descending values color | Chooses 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
An org chart with filters
The org chart displays hierarchical relationships 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.