ActiveReports 18 .NET Edition
Report Authors / Report Controls / Report Controls in Page/RDLX Report / Chart / Chart Wizard
In This Topic
    Chart Wizard
    In This Topic

    The Chart Wizard guides you through the process of creating a chart. When you drag and drop the Chart control onto the report design surface, the Chart Wizard is displayed.

    Note: The Chart Wizard is displayed only if a report is bound to a data set. For the information on how to bind a chart to data, see our walkthrough Create Clustered Column Chart.

    Chart Wizard - Select data and chart type

    The first screen of the Chart Wizard asks you to select a data set and a chart type.

    Select dataset and chart type in the Chart Wizard

    After a chart type is selected, specify the plot properties in the next screen of the wizard.

    Chart Wizard - Settings

    In the second screen of the Chart Wizard, specify the plot properties to configure the data values, category encodings, and detail encodings.

     

    For Bar, Column, Area, Polar, Spiral


    Chart Settings

    Choose Data Values

    Add - adds a data field to the Y-axis.

    Remove - removes a data field.

    Up - moves a selected data field up.

    Down - moves a selected data field down.

    Field

    The values in the Data Value Field specify the fields to be plotted on Y-Axis. If there is only one value, then the Y-Axis Title is set to the corresponding field name. If there are multiple values, but no Details encoding is set, then the chart automatically displays the global legend filled with value field names.

    Aggregate

    Data field aggregate function. An Aggregate function evaluates all the data value fields into a single value. Choose the aggregate function from Average, Count, CountOfAll, List, Min, Max, PopulationStandardDeviation, PopulationVariance, Range, StandardDeviation, Sum, Variance.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field. The title of X-Axis is set to the corresponding category field name.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sort direction is automatically set to the Category Field.

    Choose Data Subcategories

    Field

    Adds a subcategory group to the data. 

    Break-down method

    Select the way you want the additional groups to arrange from Cluster, Stacked, or Percentage. 

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sorting field is automatically set to the subcategory field.

    For Line, Radar Line, Radar Area


    Chart Settings

    Choose Data Values

    Field

    The values in the Data Value Field specify which fields should be plotted. If there is only one value, then the title of Y-Axis is set to the corresponding field name. If there are multiple values, but no Details encoding is set, then the chart automatically displays the global legend filled with value field names.

    Aggregate

    Data field aggregate function. An Aggregate function evaluates all the data value fields into a single value. Choose the aggregate function from Average, Count, CountOfAll, List, Min, Max, PopulationStandardDeviation, PopulationVariance, Range, StandardDeviation, Sum, Variance.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field. The title of X-Axis is set to the corresponding category field name.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sort direction is automatically set to the category field.

    Choose Data Subcategories

    Field

    Adds a subcategory group to the data. 

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sorting field is automatically set to the subcategory field.

    For Pie, Donut, Funnel, Pyramid


    Chart Settings

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field. The title of X-Axis is set to the corresponding category field name.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sort direction is automatically set to the Category Field.

    For Scatter, Radar Scatter


    Chart Settings

    Choose Data Values

    For scatter plot charts, the values property includes mappings for both X and Y.

    X Field

    Enter an expression to use as an X value. The title of X-Axis is set to the X Field value.

    Y Field

    Enter an expression to use as a Y value. The title of Y-Axis is set to the Y Field value.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sorting field is automatically set to the subcategory field.

    For Bubble, Radar Bubble


    Chart Settings

    For scatter plot charts, the values property includes mappings for both X and Y.

    Choose Data Values

    X Field

    Enter an expression to use as an X value. The title of X-Axis is set to the X Field value.

    Y Field

    Enter an expression to use as a Y value. The title of Y-Axis is set to the Y Field value.

    Size Field

    Enter an expression to use as the bubble size value.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sorting field is automatically set to the subcategory field.

    For CandleStick, High-Low-Open-Close, High-Low-Close


    Chart Settings

    Choose Data Values

    High Field

    Enter an expression to use as the high value.

    Low Field

    Enter an expression to use as the low value.

    Open Field (for Open High Low Close and Candlestick chart type)

    Enter an expression to use as the open value.

    Close Field

    Enter an expression to use as the close value.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field. The title of X-Axis is set to the corresponding category field name.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sort direction is automatically set to the category field.

    For Gantt


    Chart Wizard - Gantt Chart

    Choose Data Values

    Start Field

    An expression to use as the start value or the lower value.

    End Field

    An expression to use as the end value or the upper value.

    Choose Data Categories

    Field

    The category mapping in the Data Categories Field groups the data into multiple categories for each unique value (or numerical range) that exists for the specified field.

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sort direction is automatically set to the category field.

    Choose Data Subcategories

    Field

    Adds a subcategory group to the data. 

    Sort Direction

    Choose the data sorting direction from None, Ascending, or Descending. The sorting field is automatically set to the subcategory field.

    Chart Wizard - Preview

    Select a chart palette from the drop-down list. Click Finish to add the chart to the report or choose any of the advanced customization options by clicking it.

    Chart Wizard - Preview

    Select Chart Palette

    Select a color palette for the chart from a list of predefined palettes.

    Advanced Customization

    Clicking any of the advanced customization options opens a corresponding chart smart panel.

    Note: For the Pyramid, Doughnut, Pie, and Funnel chart types, the X Axis and Y Axis customization options are not available.

    To learn about the chart smart panels, see Chart Smart Panels

    See Also