Axes

Label format

Format numeric labels

By using the LabelFormat property, you can format the numeric labels. Numeric values can be formatted with n (number with decimal points), c (currency), and p (percentage) commands.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Applying currency format to axis labels--%>
        <PrimaryYAxis LabelFormat="c"></PrimaryYAxis>
        <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Label formatting in ASP NET pivot chart control

    Following table describes the result when applying some commonly used label formats on numeric values:

    Label Value Label Format Property Value Result Description
    1000 n1 1000.0 The Number is rounded to 1 decimal place
    1000 n2 1000.00 The Number is rounded to 2 decimal place
    1000 n3 1000.000 The Number is rounded to 3 decimal place
    0.01 p1 1.0% The Number is converted to percentage with 1 decimal place
    0.01 p2 1.00% The Number is converted to percentage with 2 decimal place
    0.01 p3 1.000% The Number is converted to percentage with 3 decimal place
    1000 c1 $1,000.0 The Currency symbol is appended to number and number is rounded to 1 decimal place
    1000 c2 $1,000.00 The Currency symbol is appended to number and number is rounded to 2 decimal place

    Label Format Customization

    By using the LabelFormat property of PrimaryYAxis, you can add the category labels with prefix and/or suffix.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Adding prefix and suffix to axis labels--%>
        <PrimaryYAxis LabelFormat="${value} K"></PrimaryYAxis>
        <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Label format customization in ASP NET pivot chart control

    Common axis features

    Axis visibility

    The axis visibility can be set by using the Visible property of the respective axis.

    NOTE

    By default, the value of Visible property is true in the pivot chart.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Disabling visibility of Y-axis--%>
        <PrimaryYAxis Visible="false"></PrimaryYAxis>
        <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Axis visibility in ASP NET pivot chart control

    Label customization

    By using the Font property of the axis, you can customize the font family, color, opacity, size, and font-weight of the labels.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Customizing label appearance--%>
        <PrimaryXAxis Font-Color="Blue" Font-FontSize="14px" Font-FontFamily="Segoe UI" Font-FontWeight="Bold">
        </PrimaryXAxis>
        <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Label customization in ASP NET pivot chart control

    Label and tick positioning

    Axis labels and ticks can be positioned inside or outside the chart area by using the AxislabelPosition and TickLinesPosition properties. The labels and ticks are positioned outside the chart area, by default.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Customizing label and tick positions--%>
        <PrimaryXAxis AxislabelPosition="Inside" TickLinesPosition="Inside">
        </PrimaryXAxis>
        <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Label and tick positioning in ASP NET pivot chart control

    Grid lines customization

    By using the MajorGridLines and MinorGridLines properties of the axis, you can customize the width, color, visibility, and opacity of the grid lines.

    NOTE

    By default, the minor grid lines are not visible in the pivot chart.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Customizing grid lines--%>
        <PrimaryXAxis MajorGridLines-Width="5" MajorGridLines-Visible="true" MajorGridLines-Color="Blue" MinorTicksPerInterval="1" MinorGridLines-Width="25" MinorGridLines-Visible="true" MinorGridLines-Color="Red">
        </PrimaryXAxis>
         <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Grid lines customization in ASP NET pivot chart control

    Tick line customization

    By using the MajorTickLines and MinorTickLines properties of the axis, you can customize the width, color, visibility, size, and opacity of the tick lines.

    NOTE

    By default, the minor tick lines are not visible in the pivot chart.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%-- Customizing tick lines--%>
        <PrimaryXAxis MajorTickLines-Width="10" MajorTickLines-Visible="true" MajorTickLines-Size="15" MajorTickLines-Color="Blue" MinorTicksPerInterval="1" MinorTickLines-Width="15" MinorTickLines-Size="25" MinorTickLines-Visible="true" MinorTickLines-Color="Red">
        </PrimaryXAxis>
         <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Tick lines customization in ASP NET pivot chart control

    Inversing axis

    Axis can be inversed by using the IsInversed property of the axis.

    NOTE

    By default, the IsInversed property is false in the pivot chart.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Inversing the X-axis--%>
        <PrimaryXAxis IsInversed="true"></PrimaryXAxis>
        <%--Inversing the Y-axis--%>
        <PrimaryYAxis IsInversed="true"></PrimaryYAxis>
         <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Inversing axes in ASP NET pivot chart control

    Placing axes at opposite side

    The OpposedPosition property of the chart axis can be used to place the axis at the opposite direction from its default position.

    NOTE

    By default, the OpposedPosition property is false in the pivot chart.

  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%--Placing axis at the opposite side of its normal position--%>
        <PrimaryXAxis OpposedPosition="true"></PrimaryXAxis>
        <%--Placing axis at the opposite side of its normal position--%>
        <PrimaryYAxis OpposedPosition="true"></PrimaryYAxis>
         <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Position of axes in ASP NET pivot chart control

    Smart axis labels

    When the axis labels overlap with each other based on chart dimensions and label size, you can use the LabelIntersectAction property of the axis to avoid overlapping.

    NOTE

    By default, the LabelIntersectAction property is none in the pivot chart.

    The following options that are supported for LabelIntersectAction property are:

    • Rotate45
    • Rotate90
    • Trim
    • MultipleRows
    • Wrap
    • Hide.
  • html
  • <ej:PivotChart ID="MyPivotChart1" runat="server" Url="/RelationalChartService.svc" ClientIDMode="Static">
        <%-- Avoid overlapping of x-axis labels--%>
        <PrimaryXAxis LabelIntersectAction="MultipleRows"></PrimaryXAxis>
         <Size Width="950px" Height="460px"></Size>
    </ej:PivotChart>

    Smart axis labels in ASP NET pivot chart control