Multiple Axes for ASP.NET Core PivotChart Control
23 Mar 20219 minutes to read
You can split the pivot chart and its area into multiple panes to draw multiple series with multiple axes. Additional vertical/horizontal axes in the pivot chart can be created by the axes
property.
Before rendering multiple axes in the pivot chart, you should know some important properties of axes and series of the pivot chart.
Properties of axes
- rowIndex: Specifies the index of the row where the axis is associated.
- columnIndex: Specifies the index of the column where the axis is associated.
- opposedPosition: Specifies whether to render the axis at the opposite side of its default position.
- labelFormat: Provides custom formatting for axis label and supports all standard formatting types of numerical and date time values.
-
title: You can customize the title of the axis by the following properties.
* enableTrim: Specifies whether to trim the axis title when it exceeds the chart area or the maximum width of the title.
* maximumTitleWidth: When the title exceeds the maximum width, the title gets trimmed by setting enableTrim to true.
* visible: Controls the visibility of the axis title. - name: Unique name of the axis. To associate an axis with the series, you have to set this name to the xAxisName/yAxisName property of the series.
To know more about axes properties, Click Here
Properties of series
- xAxisName: Specifies the name of the X-axis that has to be associated with this series. Add an axis instance with this name to axes collection.
- yAxisName: Specifies the name of the Y-axis that has to be associated with this series. Add an axis instance with this name to axes collection.
Customizing axes at row index of zero
You can customize the axes in the primary pivot chart itself. To achieve this, you should give the following properties:
<ej-pivot-chart id="PivotChart1" beforeSeriesRender="onBeforeRender">
<e-axes>
<e-axis name="yAxisConfig" rowIndex="0"></e-axis>
</e-axes>
</ej-pivot-chart>
<script type="text/javascript">
function onBeforeRender(args) {
for (var i = 0; i < args.series.length; i++) {
if (args.series[i].name.indexOf("Australia") != -1) {
args.series[i].yAxisName = "yAxisConfig";
args.series[i].type = "line";
}
}
return args;
}
</script>
Customizing axes at row index one
<ej-pivot-chart id="PivotChart1" beforeSeriesRender="onBeforeRender">
<e-axes>
<e-axis name="yAxisConfig" rowIndex="1"></e-axis>
</e-axes>
</ej-pivot-chart>
<script type="text/javascript">
function onBeforeRender(args) {
for (var i = 0; i < args.series.length; i++) {
if (args.series[i].name.indexOf("Australia") != -1) {
args.series[i].yAxisName = "yAxisConfig";
args.series[i].type = "line";
}
}
return args;
}
</script>
Customizing axes at column index of zero
<ej-pivot-chart id="PivotChart1" beforeSeriesRender="onBeforeRender">
<e-axes>
<e-axis name="yAxisConfig" columnIndex="0"></e-axis>
</e-axes>
</ej-pivot-chart>
<script type="text/javascript">
function onBeforeRender(args) {
for (var i = 0; i < args.series.length; i++) {
if (args.series[i].name.indexOf("Australia") != -1) {
args.series[i].xAxisName = "xAxisConfig";
args.series[i].type = "line";
}
}
return args;
}
</script>
Customizing axes at column index of one
<ej-pivot-chart id="PivotChart1" beforeSeriesRender="onBeforeRender">
<e-axes>
<e-axis name="yAxisConfig" columnIndex="1"></e-axis>
</e-axes>
</ej-pivot-chart>
<script type="text/javascript">
function onBeforeRender(args) {
for (var i = 0; i < args.series.length; i++) {
if (args.series[i].name.indexOf("Australia") != -1) {
args.series[i].xAxisName = "xAxisConfig";
args.series[i].type = "line";
}
}
return args;
}
</script>
Customizing series
You can customize the series in multiple axes support with the help of beforeSeriesRender event. You can change the series type through the onBeforeRender event.
<ej-pivot-chart id="PivotChart1" beforeSeriesRender="onBeforeRender">
<e-axes>
<e-axis name="yAxisConfig"></e-axis>
</e-axes>
</ej-pivot-chart>
<script type="text/javascript">
function onBeforeRender(args) {
for (var i = 0; i < args.series.length; i++) {
if (args.series[i].name.indexOf("Australia") != -1) {
args.series[i].yAxisName = "yAxisConfig";
args.series[i].type = "line";
}
}
return args;
}
</script>
Note: You have to use the same name in both name property of axes and xAxisName/yAxisName property of series in the above beforeSeriesRender event.
To learn more about series properties, click here
.
Multiple axes support by series index
You can render the pivot chart with multiple axes by series index.
Note: This is the default behavior of multiple axes support, if you are not triggering the beforeSeriesRender event.
<ej-pivot-chart id="PivotChart1">
<e-axes>
<e-axis name="y:0"></e-axis>
<e-axis name="x:1"></e-axis>
</e-axes>
</ej-pivot-chart>
name:'y:0' => // you can create separate y axes for the series which you want
// y indicates(yAxisName) axis in which series needs to be added.
// 0 indicates the series index of pivot chart.
// you can also use pass multiple series index separated by comma(y:0,2)
name:'x:1' => //you can create separate x axes for the series which you want
// x indicates(xAxisName) axis in which series needs to be added.
// 0 indicates the series index of pivot chart.
// you can also use pass multiple series index separated by comma(x:0,2)
For Y-axes
<ej-pivot-chart id="PivotChart1">
<e-axes>
<e-axis name="y:0"></e-axis>
</e-axes>
</ej-pivot-chart>
For X-axes
<ej-pivot-chart id="PivotChart1">
<e-axes>
<e-axis name="x:0"></e-axis>
</e-axes>
</ej-pivot-chart>
Customizing PrimaryYAxis and axes properties
labelFormat
You can customize the labelFormat for both PrimaryYAxis and custom axes.
<ej-pivot-chart id="PivotChart1">
<e-primary-y-axis label-format="c1" ></e-primary-y-axis>
<e-axes>
<e-axis label-format="n1"></e-axis>
</e-axes>
</ej-pivot-chart>
title
You can customize the title for axes by the title property.
<ej-pivot-chart id="PivotChart1">
<e-primary-y-axis title-text="Customer Count" ></e-primary-y-axis>
<e-axes>
<e-axis label-format="n1">
<e-title text="Internet Sales Amount"></e-title>
</e-axis>
</e-axes>
</ej-pivot-chart>