Progress bar using bar chart

Graphical display of data (progress bar/level) and Cell progress bar plugin can display the progress bar in the cell. In addition, the bar chart can also be used to implement the progress bar, as follows:

Insert a bar chart in the cell, then set the data and adjust the related styles.

1) Create a dataset ds1: SELECT * FROM Sales_Volume

2) The report design is as follows

Drag corresponding fields into A2, B2, and insert a bar chart into cell C2.

Note: B2 cell data needs to set Summary.

3) Set the bar chart data

Data Source: Cell Data

Category Name: =A2

Series: = "SalesVolume"

Value: =B2

4) Cancel the title to be visible

Uncheck Show Title under Style> Title.

5) Cancel the legend to be visible

Uncheck Legend Is Visable under Style>Legend.

6) Use labels

Under Style>Label, check Use Label, and check Value under Text.

7) Set the coordinate axis-X axis

Under Style>Axis>X Axis, set the Axis Label to Hidden, and the Custom Maximum Value is: =max(B2[!0])

8) Set the coordinate axis-Y axis

Under Style>Axis>Y-Axis, set the Axis Label to Hidden, the Axis Line Style Type to None, and check Off for Main Tick .

9) Remove the gridline in the background

Under Style>Background>Drawing Area, set the Gridline Vertical to None.

10) Remove the toolbar

Under Special Effect>Interaction, cancel Sort, Export Image, and Full Screen Display.

11) Save and preview

Note: Both App and Html5 are supported.

Click to download: 

Progress_bar_using_bar_chart .cpt