Custom Bar Chart

  • Last update:December 25, 2024
  • Overview

    Version

    Report Server Version
    11.0

     

    Application Scenario

    When standard bar charts cannot meet your specific needs for data presentation, you can use custom bar charts to customize multiple axis.

    自定义条形图1.png

     

    Chart Feature

    Advantage: The high degree of flexibility and creativity of custom bar charts allow you to draw the viewer's attention through unique designs to better convey certain information.

    Disadvantage: Designing and creating custom bar charts may cost more time and resources, and improper design may reduce the clarity and readability of data.


    Example

    Data Preparation

    Choose File > New General Report in the upper left corner of the designer, and create a dataset ds1. The database query statement is as follows: 

    SELECT Category_Name, Inventory_Quantity, Order_Quantity, Reorder_Quantity FROM Product, Category

    WHERE p.CategoryID = c.CategoryID AND Category_Name != 'Daily necessities'

    ORDER BY Category_Name.

     自定义条形图2!.png

     

    Chart Insertion 

    Merge required cells, click Insert Chart on the upper toolbar, and choose Bar Chart > Custom

    自定义条形图3.png 

     

    Chart Design

    Select the chart, click the Cell Element icon on the right property panel, and set the properties (Type, Data, Style, and Special Effect) for the chart. 

    Chart Type

    Select the cell where the chart is located and choose Cell Element > Type to view and select the chart type.

     自定义条形图4.png

     

    Data Binding

    1. Select the chart and choose Cell Element > Data on the right property panel.

    2. Bind the data in the Dataset. Select ds1 for Dataset, Category_Name for Category, Field Name for Series Name (Inventory_Quantity and Order_Quantity fields), and Sum for Summary.

    自定义条形图5.png 

     

    Chart Style Setting

    1. Select the chart, choose Cell Element > Style > Title and enter the text Custom Bar Chart.

    2. When you select Custom Bar Chart, X Axis 2 will be added by default on the top of the chart. You can follow this default setting.

     6.png

     

    3. Follow the steps as shown below, so that the X Axis at the bottom corresponds to the value of Series 2 and the X Axis 2 at the top corresponds to the value of Series 1. Select No for the Stacked effect.

     7.png

    Effect Display

    PC

    Save the report and click Pagination Preview. The effect is same as that shown in section "Application Scenario". 

    Mobile Terminal

    The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the display effect.

     8.jpg

     

    Template Download

    For details, you can click to download the template Custom Bar Chart.cpt


    Attachment List


    Theme: Chart
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    8s后關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy