Creating Bar Chart Widgets in Pronnel Boards: A Step-by-Step Tutorial

Bar charts are a powerful way to visualize data, offering clear insights into key metrics and distributions. In Pronnel Boards, you can use the Bar Chart Widget to represent data effectively.
This tutorial will guide you through creating Bar Chart Widgets to visualize the distribution of tasks across different statuses or stages, helping you track progress and workload with ease.

Step 1: Accessing Dashboard Creation:

Begin by accessing your Pronnel workspace. In the relevant Work Folder, you can create a new Dashboard or use an existing Overview View to display widgets. When setting up the Dashboard, ensure that the appropriate boards are connected so that the data is accurately reflected in your Bar Chart Widget.

Accessing Dashboard Creation

Step 2: Creating a Bar Chart Widget:

Once your dashboard is ready, click the top-right corner to add a new widget. Choose the "Chart" option, then select "Bar Chart" from the available chart types.

Creating a Bar Chart Widget

Step 3: Configuring the Bar Chart Widget::

Upon selecting the Bar Chart Widget, you'll need to configure its settings:

X-Axis:

The X-axis represents the horizontal axis and displays data categories. For our example, select a bucket representing task status (e.g., "Open," "In Progress," "Done"). You can also apply sorting criteria on the X-axis to control the display order of categories.

Y-Axis:

Choose the metric to display on the Y-axis. You can select the calculation type as Count, choose from available Columns, or use a custom Formula. Formulas allow arithmetic operations like Sum, Average, Median, Min, Max, and more—offering flexibility to tailor the chart based on your analysis needs.

configure x-axis and y-axis

Within the Y-axis settings, you can also select a Display TypeBar, Line, or Scatter—to represent your data visually in the most meaningful format.

configure display type in y-axis

Additionally, you can set a Target or Upper Limit on the Y-axis. This helps you visually benchmark performance by adding a reference line that indicates goals, thresholds, or expected values.

Add Description:

Enable the "Add Description" option to include a note explaining the widget's purpose. This helps others understand the widget's context and relevance.

Add Description

More Settings:

  • Customize your Bar Chart widget further using the available settings:
  • Show or hide X-axis and Y-axis label names.
  • Select the value type representation—choose between percentage scale or number scale.
  • Visualize bars as 100%, cumulative, or cumulative with 100% visualization.
  • Flip the chart to switch the orientation of axes.
  • Choose how you want the chart and data table displayed: graph only, table only, or both.
  • Connect one or more boards such as Bug Tracking or My_Project to pull data dynamically.
Flip the chart

Step 4: Filtering Data:

Utilize the filter icon located at the top-right corner to refine the data displayed in the Bar Chart.
For instance, if you want to focus on active tasks only, you can filter to exclude functions in the "Final" bucket, providing a clearer view of task status division.

Filtering Data

Step 5: Review:

Review the configured settings to ensure they meet your requirements. You can also toggle between chart and table views to visualize the data as needed.

Review the configured settings

Conclusion:

Congratulations! You've successfully created a Bar Chart Widget in Pronnel Boards to visualize task status distribution. This allows you to monitor progress across different stages and gain clear insights. Feel free to explore additional settings and filters to customize your chart for deeper analysis and better decision-making.

FAQ

What is a Bar Chart Widget in Pronnel Boards?

A Bar Chart Widget in Pronnel Boards is a visual representation tool that displays data categories and their corresponding values as rectangular bars. It offers a clear overview of data distributions and metrics.

How do I access the dashboard creation feature in Pronnel Boards?

To access dashboard creation in Pronnel Boards, navigate to your boards and select the option to create a new dashboard. Alternatively, you can add widgets directly to an existing overview view on your board.

What types of data can I visualize using the Bar Chart Widget?

Using the Bar Chart Widget, you can visualize various data types, such as task status division, project progress, issue tracking, and more. The widget allows you to represent any numerical value associated with data categories.

How do I configure the X-Axis in the Bar Chart Widget?

The X-axis represents categories such as task status (e.g., "To Do," "In Progress," "Done"). Select a relevant field to group your data accordingly.

What options are available for the Y-Axis configuration?

You can select calculation types like Count, or use values from specific columns. Formulas also allow arithmetic operations like Sum, Average, Median, Min, and Max for flexible analysis.

Can I add a description to the Bar Chart Widget?

You can add a description to the Bar Chart Widget by enabling the "Add Description" option. This allows you to include a note explaining the widget's purpose, providing context for other users.

How can I further customize the Bar Chart Widget?

Under "More Settings," you can adjust the legend position, flip axis orientation, choose connected boards as data sources, and sort the data for clearer insights.

How do I filter data in the Bar Chart Widget?

Use the filter icon at the widget's top-right corner to refine the data displayed in the Bar Chart. For example, you can filter to exclude certain categories or focus on specific subsets of data, such as active tasks only.

Can I save and review the configured settings before finalizing the Bar Chart Widget?

You can review the configured settings before saving the Bar Chart Widget to your dashboard. This allows you to ensure that the widget meets your requirements and displays the desired data visualization accurately.

Are there any additional tips for maximizing the effectiveness of the Bar Chart Widget?

Customize configurations, apply relevant filters, and connect the right boards to ensure your Bar Chart reflects up-to-date project data and insights.