ActiveReports 19 .NET Edition
Report Authors / Report Controls / Report Controls in Page/RDLX Report / Chart / Customize Chart Appearance
In This Topic
    Customize Chart Appearance
    In This Topic

    You can customize the chart appearance by changing these target properties of the chart plot.

    Custom Labels

    Set Custom Labels for X-Axis

    Let us add custom labels in the following chart, where the default labels for the X-Axis show Ship Names since the Category Groups area is bound to [ShipName]
    The chart binds to the 'Invoices' table of the Nwind.db. See Custom Data Provider for more information.
    Label Axis

    You can customize the X-Axis labels of the above chart as follows to show 'City' along with 'Ship Name'.

    1. From the Category Groups area, select the field, [ShipName], which is displayed along the X-Axis.
    2. In the Properties window, go to Label property and set it to the following expression:
           =Fields!ShipName.Value + " , " + Fields!City.Value    
    3. Now select the X Axis and go to Labels > LabelsAngle property and set it to say, '45' degrees.
    4. Go to Title > Title and set it to 'Ship Name, City', to display this text as the X-Axis's title.
    5. Preview the report.

    The below image shows how the X-Axis labels show customized labels.

    Customized X-Axis Labels


    Set Custom Labels for Chart Data Series

    Let us add custom labels for the chart data series in the chart created in the Create Multiple Line Chart tutorial by following the below steps.

    1. From the Chart Data area, select the [Sales Amount] field.
    2. From the Properties panel, go to Appearance > Labels > Value property and set the property to the following expression:
       =Sum(Fields!SalesAmount.Value) & " $"
    3. Preview the report.
      Customized Labels for Data Series


    ToolTips

    To add a tooltip in a chart with ['Global_Sales'] as chart data, displayed along the Y-Axis, follow the below steps:

    1. From the Chart Data area, select ['Global_Sales'].
    2. Set DataToolTip > Value and add the expression to display the field; e.g.
      =Sum(Fields.Item("['Global_Sales']").Value)
    3. Set the DataToolTip > Format to 'c'.
    4. Preview the report.
      Displaying tooltips in Charts

     

    Conditional Chart Formatting

    Select the series data and use expressions as follows in the corresponding properties to see the effect. Refer to the Create Clustered Column Chart tutorial, with only one series for simplicity.
     

    FillColor

    Conditional Chart Formatting - Fill Color

    Select the Chart Data series (here [Net Sales]) and from the Properties panel, set the expression of FillColor property to the following:

    Copy Code
    IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Red")
    


    LineColor/LineStyle/LineWidth

    Conditional Chart Formatting - Line color, style, width

    Select the Chart Data series (here [Net Sales]) and from the Properties panel, set the expression of LineColor, LineStyle, and LineWidth properties respectively to the following:

    LineColor
    Copy Code
    =IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Red","Grey")
    

     

    LineStyle
    Copy Code
    =IIF(Sum(Fields.Item("Net Sales").Value)>450000,"Double","Dotted")
    

     

    LineWidth
    Copy Code
    =IIF(Sum(Fields.Item("Net Sales").Value)>450000,"4pt","1pt")
    

     

    For charts such as Line, Radar Line, which are composed of markers or data point symbols, have the properties that can be set for conditional formatting. For example, in Create Single Line Chart tutorial, we can highlight the markers as shown.

    Line Chart Markers

    To do so, with the Chart Data series (here [Return Quantity]) selected, from the Properties panel, go to Marker > BackgroundColor. and set the expression to the following.

    Example Title
    Copy Code
    =IIF(Sum(Fields!ReturnQuantity.Value)>5,"Red","Grey")
    

    Similarly, expressions for Marker border settings > LineColor, LineStyle, and Width can be set.