Version
Diagram Step 3.png

Chart Views

You can select any of the chart icons displayed in the Visualizations options menu as long as it is suitable for your data. ReportPlus will select the first numeric columns in the dataset and attempts to match the selected chart type data series requirements.

TwoMoreSeriesChart

For instance, in a Column Chart all numeric columns are added to the chart, and for a OHLC chart, different columns with the Open, High, Low and Close series are expected. The automatic selection of columns done by ReportPlus can be modified in the Chart Settings configuration.

Single series chart types

Single series chart types show the relationship between information contained in a single data set. The available chart types are:

ChartsSingleSeries_Desktop

Two or more series required chart types

These chart types show relationships between two or more sets of data. The available chart types are:

ChartsTwoMoreSeries_Desktop

Chart Data

When you choose a chart type, ReportPlus will automatically select the columns used for the X Axis & Y Axis data. But this selection may not always have the expected outcome when visualizing the data. The Chart Data configuration option allows you to select which columns must be taken into account for the chart creation. You can configure both the columns that should be used for chart rendering and the Label options.

In the 2 Y-Axis chart, you can select which numeric columns are displayed in the left and right axis.

PivotEditorView2YAxis_Desktop

Advanced Chart Settings

If you click and expand the Advanced section of the Visualization settings, you will be able to modify:

Left and Right Axis Configuration

ReportPlus also allows to set the range of minimum and maximum values for the axis and to specify whether it’s linear (by default) or logarithmic.

Chart Trendlines

Chart settings enable the display of trend lines, which are lines that are painted across a chart, based on an algorithm. Trendlines are a very simple, yet powerful tool to help you determine trends in data sets, and define thresholds for taking action. The supported algorithms are Linear Fit, Quadratic Fit, Cubic Fit, Quartic Fit, Logarithmic Fit, Exponential Fit, Power Law Fit, Simple Average, Exponential Average, Modified Average, Cumulative Average, Weighted Average.

Percentage Distribution

You can also configure this feature for the stacked series charts. It will override the 0-100 default scale and allow you to visualize the percentage distribution of the values in the chart.

PivotEditorView_StackedPercentageDistribution_Desktop

Start Position and Slice Labels

For Pie and Doughnut charts, you can configure the start position for the chart to rotate the slices and change the order in which your data is presented.

PieDoughnutStartPosition Desktop.png

For Funnel, Pie, and Doughnut charts, you can configure slice labels in order for the visualization to display values, percentages, or both at the same time.

PivotEditorViewSliceLabels_Desktop