Customizing Charts

Customizing a Chart

When designing a chart, ManageEngine Analytics Plus offers wide range of options to customize the chart and improve the overall appearance in different ways. In this section we will discuss about various options provided by ManageEngine Analytics Plus to customize the chart that you create.

General Settings

The General Settings tab allows you to modify the title, add a short description, and configure display settings for data. To customize the settings, open the required chart, and click the Settings icon in the toolbar.

The following are the available options:

OptionDescription
General
TitleSpecify a unique title for the chart. This is mandatory.
DescriptionSpecify a description for the chart. This is Optional.
Display
Display 'Unknown' value asSpecify a value you want to display in the chart for the null or empty values.
Show Missing ValuesChoose the Show Missing Values checkbox to include the data points (date/categories) which do not have any corresponding value in the underlying data. Deselecting this will skip these points in the axis.
Chart EffectThis option allows you to apply an effect over your chart. Select the Default option if you wish to generate the chart without any effects.
Data LabelEnable this option to display the underlying value as a data label on the chart.
Show Conversion RateSelect this to display the conversion rate of the funnel in percentage by comparing the value of the last slice with the first slice in the funnel.
Funnel DesignSelect one of the following funnel designs: Weighted height, Uniform height, and Heighted width.

Axis Settings

ManageEngine Analytics Plus will automatically set values for chart axes properties such as X-axis and Y-axis labels, axis range, interval between labels, etc., while creating a chart. You can also customize these properties to suit your needs using the Axis tab in the Settings screen.

To customize axis settings:

  • Open chart and then click Settings option in the toolbar.
  • The Settings screen will open. Click the Axis tab. You can also open the Axis tab by clicking the settings icon next to X/Y Axis in Edit Mode.

 

The following table describes various options available in Axis tab.

OPTION                        DESCRIPTION
X Axis
Label

This option consists of two fields. They are:

Name - Text field to specify the name of the X-axis. By default, the name of the corresponding column will be set as axis label.
Font - Multi-column drop-down displaying options to customize the font style, size and color of the X-axis label.

Tick Marks

Font:

This option is used to set the font style of the tick marks in X axis. It contains a multi-column drop-down displaying options to customize the font style, size and color of the tick mark.

Direction:

This option can be used to set the orientation of X-axis tick labels. Available options are:

  • Auto - Align the tick labels in the most appropriate direction based on the number of characters in the tick label.
  • Horizontal - Align the tick labels in a horizontal direction.
  • Vertical - Align the tick labels in vertical direction (90-degree angle to the axis).
  • Slanting - Align the tick labels in slanting direction (45-degree angle to the axis).
Format

This option will be available only for a numeric column added in the axis. The Format link to format the numeric data for the tick marks. These options will be similar to that of the table column formatting. For more details refer here.

Range

ManageEngine Analytics Plus will automatically calculate the X-axis range based on the maximum and minimum values in the data series.

If required, you can set a custom range by selecting the Range check box and then entering the maximum and minimum values in the corresponding fields.

This option will be available only when numeric data columns are added to the X-axis and the chart type is set to Line, Area or Scatter chart.

Interval

ManageEngine Analytics Plus will automatically determine the interval between axis labels based on the axis label length and the size of the chart.

If required, you can set a custom interval by selecting the Interval check box and then enter the interval value in the corresponding field.

This option will be available only when numeric data columns are added to the X-axis and the chart type is set to Line, Area or Scatter chart.

Y Axis
Label

This option consists of two fields. They are:

  • Name - Text field to specify the name of the X-axis. By default, the name of the corresponding column will be set as axis label.
  • Font - Multi-column drop-down displaying options to customize the font style, size and color of the X-axis label.
Tick Marks

Font:

This option is used to set the font style of the tick marks in X axis. It contains a multi-column drop-down displaying options to customize the font style, size and color of the tick mark.

Direction:

This option can be used to set the orientation of X-axis tick labels. Available options are:

  • Auto - Align the tick labels in the most appropriate direction based on the number of characters in the tick label.
  • Horizontal - Align the tick labels in a horizontal direction.
  • Vertical - Align the tick labels in vertical direction (90-degree angle to the axis).
  • Slanting - Align the tick labels in slanting direction (45-degree angle to the axis).
Data LabelThis option can be used to display Y-axis values as data labels in the chart. On selecting this option a text string which displays the Y value corresponding to each data point will be added.
Note: In case, if you have dropped a column in to the Text shelf when creating a chart, then it will override the data label setting provided.
Format

This option will be available only for a numeric column added in the axis. The Format link to format the numeric data for the tick marks. These options will be similar to that of the table column formatting. For more details refer here.

Range

ManageEngine Analytics Plus will automatically calculate the X-axis range based on the maximum and minimum values in the data series.

If required, you can set a custom range by selecting the Range check box and then entering the maximum and minimum values in the corresponding fields.

This option will be available only when numeric data columns are added to the X-axis and the chart type is set to Line, Area or Scatter chart.

Interval

ManageEngine Analytics Plus will automatically determine the interval between axis labels based on the axis label length and the size of the chart.

If required, you can set a custom interval by selecting the Interval check box and then enter the interval value in the corresponding field.

This option will be available only when numeric data columns are added to the X-axis and the chart type is set to Line, Area or Scatter chart.

ScaleThis option allows you to specify the label ticks scale. The following are the available options:
  • Linear: Adds tick in linear number sequences as 100, 200, 300 with equally spaced grid lines.
  • Log: Adds tick in log number sequences as 10,100, 1000 with equally spaced grid lines.
  • Square Root: Adds tick in square root sequences as 5, 25, 625 with unequally spaced grid lines. Spacing between the grid lines decreases as value increases.

Note:

  • The Axis tab is not applicable for Pie and Web chart types, as they do not have any axis.

Borders and Colors

When a chart is created, ManageEngine Analytics Plus will set the default background and border for the new chart. However, you can customize these setting to enhance the look and feel of the chart. The Borders & Colors tab in the Settings screen provides various options to customize the chart appearance.

  • To customize the chart appearance:
  • Open chart and then click Settings option in the toolbar.
  • The Settings screen will open. Click the Borders & Colors tab.
  • Customize the chart and then click Apply.

The following screenshot illustrates the Borders & Colors tab.

 

The following table describes various options available in the Borders & Colors tab.

OPTION                        DESCRIPTION
Chart Fill Color

This option is used to customize the default color of the chart fill for single data series.

Border Style

This option is used to customize the chart border. This consists of two options.

  • A drop-down to set the border line style.
  • A color picker to set the border line color.
Grid line Style

This option is used to customize the chart grid line. This consists of two options.

  • A drop-down to set the grid line style.
  • A color picker to set the grid line color.
Background Color

This option is used to set the chart background. Available options are:

  • Default - Set the default setting as chart background.
  • Normal - Set the selected single solid color as the chart background.

Legend Settings

Legend in a chart provides a quick overview of the different data series involved in the chart along with the color associated with each series. Legend consists of Legend Title and Legend Items. Each legend item consists of a colored box that indicates the data series and the name of the data series.

In ManageEngine Analytics Plus, by default the legend will be placed on the right side of the chart and legend items will be added to it depending on the data series involved in the chart. You can customize the legend position, legend title, legend filters and the colors of each data series easily.

To customize the legend:

  • Open the corresponding chart and click Settings option in the toolbar.

  • The Settings screen will open. Click the Legend tab.

  • The Legend tab provides various options to customize the legend properties. Set the options as required and click Apply.

The following table describes the options available in the Legend tab:

OptionDescription
Legend PositionThis option allows you to set the position of the Legend in a chart. Supported positions are:
  • Hide
  • Auto
  • Right
  • Left
  • Top Left
  • Top Center
  • Top Right
  • Bottom Left
  • Bottom Center
  • Bottom Right
Title

This option has two fields. 

  • A checkbox which allows you to show or hide the legend title. 
  • A text field, in which you can change the default title of the legend. You can also customize the font style of the legend title using the drop down next to this field.
FontUsing this option you can customize the font style of the legend items.
Legend Style

Specify whether to display the legend items with or without the corresponding values. 

You can also customize the format to display data using the Format link. 

Legend FiltersSelect this option to enable legend items to act as filters in the chart view mode. This allows users to dynamically filter the data series using the legend items. 
Click here to know how to use legend filters to filter a data series.
Palette Type

Analytics Plus offers three types of palettes for the legends. They are:

  • Solid color
  • Monochrome
  • Gradient
Color Palette Select the color palette that you want to apply to your data series. 
You can also select a color palette based on the Palette Type that is selected. Analytics Plus has a predefined set of color palettes that you can choose from. Apart from this, you can also add new color palettes.
Colors Using this option, you can override the colors of the individual series of the chart. Once you override the palette, you will find the following options. 
  • Use Palette colors: Click this to reset the color to the selected palette. 
  • Save as New Palette: Click this to save the selected colors as a new palette for the workspace. 

The following screen shot illustrates the resulting legend, when Show Legend Title and Legend Filters options are selected and Legend Position is set to Bottom Left

You can also change the color of each data series using the corresponding legend item in Edit mode. 

Adding Threshold

ManageEngine Analytics Plus provides an option to draw threshold lines in charts to highlight specific values. Threshold lines can be added horizontally or vertically at a fixed value on the X or Y-axis of a chart. A threshold will be useful to highlight specific values for better visualization and for comparing the data series. 

For example, you can set a threshold line to represent sales target, and another to represent the lowest acceptable sales for a particular month. This helps to spot regions that are out of this range. 

To add a threshold in your chart:

  • Open the corresponding chart and click the Settings option in the toolbar.
  • Click the Threshold tab in the Settings screen.

You can configure the following settings.

  • Scope: Select the Scope of the Threshold. 
    • Entire Table: Applies the same threshold for the entire dataset represented in the report.
    • Per Cell: Applies different threshold lines for each data point represented in the report. 

Example: The following images illustrate charts with a single threshold line for the entire chart and multiple threshold lines for each data point in a chart.

Single threshold line:

Multiple threshold lines:

  • Reference axis: For charts with multiple y-axes, select the axes you wish to use as reference from the Reference Axis drop-down. 
  • Value: Analytics Plus provides the option to choose static or dynamic threshold values. 
    • A static threshold is a reference line set at a constant value. This value is added manually by selecting Constant from the Value drop-down. 
    • A dynamic threshold is a reference line drawn to represent computed values such as minimum, maximum, average or sum of columns in your reference axis. To add a dynamic threshold line, select a function from the Value drop-down. 

Example: The below image illustrates a case where a dynamic function, namely average sales, has been set as the threshold. 

  • Enter the desired label for the threshold line in the Name text box.
  • Select the line type and color from the Formatting drop-down.
  • You can add more thresholds using the +Add Threshold link.
  • Click Apply once you have added required threshold lines.

Note: You can remove an existing threshold any time using the Remove link next to the corresponding threshold in Settings screen. 

Chart Drill Down Path

The Drill Down tab allows you to set a drill down path for your chart axis. This path is specific to the chart where you are defining it.

Setting a drill down path

Follow the steps below to do this. 

  • Open the corresponding chart and click Settings option in the toolbar.

  • The Settings screen will open. Click the Drill Down tab.

  • The Drill Down tab will open. In case if there is any drill paths already defined at the table level it will be displayed by default.

  • You can modify the drill down paths or define new path for the chart axis.

  • Click Apply. The drill down path will be defined for this chart.

If you want to define the path globally (i.e., for all charts), then you need to define that for the corresponding columns at the table level. 

Disabling drill down

You can disable the drill down option in your chart by deselecting the required options in the Drill Down tab of the chart's Settings page. 

  • Drill Down: Deselect this to remove the drill down option from your chart completely.

  • X-Axis Path: Deselect this to remove the drill down option based on X-Axis' column path.

  • Color Path: Deselect this to remove the drill down option based on the chart's Color column.

  • Allow Dynamic Drill Down: Deselect this to remove the dynamic Drill Down By option from the chart. 

Drill through

The drill-through function in Analytics Plus allows you to link two related reports, enabling seamless navigation between them. When users drill down into a report, they can open the related report, providing a more detailed and connected view based on the specific data point.

Follow the steps below to set up a drill through,

  1. Open the desired chart, and click the settings icon at the top right corner.

  2. In the right pane that pops up, scroll down and expand the Drill option.
  3. Enable the Drill Through toggle button, and click the Edit link next to it.

  4. In the dialog that opens, choose the related views you want to drill through from the current view.

    You can search for the specific view using the search bar. ‌You can also sort the views in ascending or descending order based on their name or type for easier selection.

    ‌To remove a selected view, hover over the view name, and click the delete icon that appears. Click the Remove All link to remove all the selected views and add new views.

  5. Click Apply.

  6. Click Save to save the report.

Working with drill through

  • Click any data point in the report and choose Drill Through.

  • Select the desired report you wish to jump.

The selected report will open in a new tab with filters applied according to the chosen data point.

Disable drill through

  • Open the desired chart, and click the settings icon at the top right corner.

  • In the right pane that pops up, scroll down and expand the Drill option.
  • Disable the Drill Through toggle button, and click Save.

Customizing Chart Color

In ManageEngine Analytics Plus, when you create a chart, colors to represent the various data series involved will be automatically added to your chart. However, you can change the default colors of the data series.

To customize the data series colors in your chart:

  • Open your chart in Edit Design Mode.

  • Click on the color box of the legend item of the data series for which you want to change the color.

  • Select Change the Legend Color option in the menu that shows up.

  • A color picker dialog opens. Choose the required color from the full range of colors available. You can also specify the color by specifying the RGB value or the Hexadecimal value in the corresponding fields provided.

  • Click OK after choosing the required color.

The newly chosen color will show up in your chart for the corresponding data series as shown below.

 

Note: 

  • You can also customize the color of the single data series using the Chart Color Fill option in the Borders & Colors tab in Settings screen. 

Format options in charts 

The format menu offers a centralized location to customize the X axis, Y axis, color, and tooltip.

To customize these components,  

  • Click on the Settings button > Select the Format menu.
  • Click on the Format button beside the Tooltip Label.

chart-settings-format

For date fields, you can choose from a list of date formats, or create your own custom format using the text box.

chart-format-date

The format options for a currency type column are: 

  • Currency Symbol - you can choose country-specific currency symbols from the drop-down.
  • Units - You can select units in the range of Thousands (K), Millions (M), Billions (B), or choose Auto to let Analytics Plus display the closest unit. 
  • Decimal Places - You can choose to display up to 10 decimal places for a column. 
  • Negative Number Display - You can choose how sub-zero values are displayed on your charts. 

chart-format-currency

Similarly, for a percentage value data type, you can select the number of decimal places, separator, and choose to show or hide the percentage symbol.

chart-format-percentage

Note:
1. You can use all three methods to format the Week & Year Format of the columns with the Date data type.
2. The changes made will be applied only to this report. There are five Week and year Formats available - Short, Medium, Long, Start Date, and End Date.



3. You can also change the Week & Year format for the entire workspace. Click here to learn more.

Displaying images in charts

Analytics Plus allows you to display images in the place of text in a chart's axis. You can do this by converting the image URLs in a table into the corresponding images.

The following is a sample table with an image URL column:

Follow the steps below to convert the image URLs into the corresponding images in charts:

  • Open the required chart in the Edit Design mode.

  • Add the image URL column to either the X or Y-axis shelves, or the Color shelf and click the Click Here to Generate Graph button.

  • Click the Settings icon in the top-right corner.

  • Navigate to the Format section and click the required Format link.

    In the pop-up that appears, choose Image from the Display As drop-down, select the required dimension from the Image Dimension drop-down, and click OK.

    You can also provide custom dimensions for the images using the Custom option under the Image Dimension section.

  • Click Apply to replace the URL text with the corresponding images in the chart.

Note: Images cannot be displayed inside Tooltips.

Share this post : FacebookTwitter