Topics

See more

Bar Chart

Configure Bar Chart

Data Configuration

Visual Configuration

User-Defined Colors

Configuration Options in Full-Screen Mode

A Bar chart represents categorical data using bars of different heights/lengths.

One axis (X-Axis) of the chart shows the categories called the Dimension, and the other axis (Y-Axis) shows the measured value for each of the categories called the Measure. The measure can be calculated from any of the aggregate (e.g. count/sum/average etc.) functions. The height of the bars represents the measure.

In the example below, a Bar chart is created to compare issue allocation across assignees.

To create a Bar chart:

  • Right-click on the Assignee column > Select View> Change> Bar.

1B.png

Refer here to learn more about creating a visualization.

The following figure shows the resulting Bar chart.

1.png

Configure Bar Chart

To configure:

  • Select your Bar chart and open the Visualizations Panel.

2.png

The following configuration options are available for Bar chart:

mceclip1.png

  1. Data Configuration mceclip7.png: It lets you choose columns for the following settings:
    1. X-Axis
    2. Y-Axis
    3. Color By
    4. Color saturation
    5. Sorting
  2. Visual Configuration mceclip8.png: It lets you configure the visual appearances and interactions of Bar chart.
    1. Label Style
    2. Bar Options
    3. X-Axis
    4. Y-Axis
    5. Zoom
    6. Legend
    7. Container Settings
    8. Visual Interactions
  3. Visualization Level Filters mceclip9.png: They let you filter the data in the visualization without impacting the other visualizations. 
    Refer here to learn more about Visualization Level Filters.
  1. User-Defined Colors mceclip10.png: They let you add meaning to a data point by associating a specific color to it. User-defined colors also help you to differentiate a data point from the rest.
  1. Colors for Individual Data Item
  2. Color Saturation Settings 

 Data Configuration

  • Click on the mceclip11.pngicon for data configuration options.

X-Axis

Specify the column which contains specific categories to be compared. 

To change the column on X-Axis:

  1. Click on the  mceclip12.png icon to remove the existing column.
  2. From the Data Panel, drag the desired column and drop it onto the Visualizations Panel’s “X-Axis” section.
    Note.pngNote: You can also type the column name in the Data Panel to quickly find it.

Date and Time Grouping on X-Axis

You can create Bar charts by setting date and time values to X-Axis. When specifying a column with date and time on X-Axis, you can group the dates on  Year, Quarter, Month, Week, Day, Hour, and Minutes.

  1. From the Data Panel, drag the Date, DateTime and Time type column and drop it onto the Visualizations Panel’s “X-Axis” section.
  2. Click on the mceclip13.png icon and select ‘Group By’.
  3. Select an appropriate interval.

1_Data_config-min.gif

Y-Axis

The heights of the bars represent a certain measured value for each of the categories. On the Y-Axis, specify the column whose values should be aggregated for the chosen categories. 

To change the column:

  1. Follow the same steps as shown above for “X-Axis”.
  2. Click on the mceclip14.png   icon to select the aggregate function from the drop-down.
    • Aggregate functions for textual data: Count, Unique Count
    • Aggregate functions for numerical data: Count, Unique Count, Sum, Min, Max, Avg
      5.png
  3. You can add multiple columns to the Y-Axis to create stacked or grouped Bar chart.
  4. You need to separately select aggregate functions for each of the columns added to Y-Axis, as explained above. 

Refer here to learn more about the stacked and grouped Bar charts.

In this example, a stacked Bar chart with  “Key’ and “Resolved’ columns on Y-Axis enables you to compare the total number of issues vs resolved issues for each assignee. 

6.png

Color By

You can have different colors for the bars on the basis of X-Axis values.

  • Drag and drop the “X-Axis column” from the Data Panel onto the Visualizations Panel’s ‘Color By’ section. 

You can also split each bar into another categorical column in the data. This enables you to see the contribution from different categories to each bar. This is another way of creating multi-bar (stacked/grouped) visualization.

For example, if you choose ‘Issue’ Type for ‘Color By’ Setting, then a specific color will be applied to each of the issue types such as ‘Epic’, ‘Story’, ‘Bugs’ etc.

  • Drag and drop the desired column from the Data Panel onto the visualizations Panel’s ‘Color By’ section. 
Note.pngNote: ‘Color By’ option cannot be applied with multiple columns on Y-Axis. Remove the multiple columns from Y-Axis to apply the ‘Color By’ and vise Versa.

2_Color_By-min.gif

Color Saturation

You can use color gradients to show the progression of data from high to low values. Each bar will be colored with a shade from the spectrum between the two colors defined as ‘Minimum’ and ‘Maximum’. 

To apply color gradients:

  1. Drag the desired column from the Data Panel and drop it on the Visualizations Panel’s “Color Saturation” section.
  2. Select the aggregate function by clicking on the mceclip15.png icon. 

In this example, the Bar chart reflects the gradient with light colors for low values and dark colors for high values calculated as Count (Key). 

8.png

To customize the shades of color saturation, refer to section- ‘Color Saturation Settings’.

Note.pngNote: Color Saturation cannot be applied if ‘Color By’ is already configured. Remove the ‘Color By’ setting to apply the ‘Color Saturation’ effect. 

Sorting

You can sort the Bar chart on X-Axis or the height of bars defined by values on Y-Axis. 

Note.pngNote: By default,  the Bar chart is sorted on X-Axis.

To change the sorting:

  1. Click on the mceclip16.png icon and select the column from the drop-down.
  2. Click on the mceclip17.png or mceclip18.png icon to change the sorting order (ascending or descending).
  3. Click on ‘Add Level’ to add multi-level sorting.
  4. Drag and drop columns within the sorting section to reorder the sort levels.
  5. Click on the mceclip19.png icon to remove the sorting level. 

To learn more about sorting,  refer to the following GIF. 

Note.pngNote: Steps for sorting are same for Grid and Bar chart. 

3_Sorting-min.gif

Visual Configuration

  • Click on the mceclip20.png icon for visual configuration settings. 

Labels

You can hide or show the data labels by this toggle switch.

  1. Provide the font size of data labels.
  2. Click on the mceclip21.png icon and select a font color. To restore the default color setting, click ‘Reset to Default’. 

mceclip2.png

Bar Options

Bar charts have two variations-

  • Grouped
  • Stacked

They can be really useful to display information about the sub-groups that make up the different categories. These are usually colored differently which makes it easy to distinguish between sub-groups.

  • Click on the mceclip22.pngicon to see the options for Bar chart type. 

mceclip3.png

Note.pngNote:  You can add a legend to indicate what each sub-group represents.

Stacked Bar Chart

In Stacked Bar charts, the bars representing the sub-groups are placed on top of each other to make a single column. They are great for showing the total because they visually aggregate all of the categories in a group.

Here is the Stacked Bar chart: 

11.png

Grouped Bar Chart

In Grouped Bar charts, a separate bar represents each of the sub-groups (e.g. Issue types). They are useful when you want to see each element in different categories or compare elements across categories. 

12.png

X-Axis

  • Type in the title for X-Axis

mceclip4.png

Y-Axis

  • Choose the number of decimal places you want to display values with.
  • Select the Axis type.
  • Type in the Axis title. 

mceclip5.png

Axis Types

There are two ways to plot values in a Bar chart - linear and logarithmic.

On a linear scale, a change between two values is perceived on the basis of the difference between the values, whereas, on a logarithmic scale, this change is perceived on the basis of the ratio of the two values. 

The main reason to use logarithmic scales in charts and graphs is to respond to skewness towards larger values; i.e., cases in which one or a few points are much larger than the bulk of the data. 

When plotting disparate data on a linear scale, the smaller values get lesser prominence while the larger ones occupy the entire scale. In such cases, using a logarithmic Axis type is recommended.

The following figures demonstrate the Bar charts with linear and log axis types, created for the same data.

Bar chart on the linear axis: 

bar-with-linear-axis.png

Bar chart on the logarithmic axis: 

bar-with-log-axis.png

When plotting disparate data on a linear scale, the smaller values get lesser prominence while the larger ones occupy the entire scale. In such cases, using a logarithmic Axis type is recommended.

Zoom Options

This option enables you to clearly understand specific data in your Bar chart by zooming it.

  1. Keep the Zoom Options ‘On’ by selecting the toggle switch.
  2. For the Zoom Panel, select the ‘Show’ option from the drop-down list to select the part of your chart by dragging its edges in either direction.
  3. Select the ‘Hide’ option from the drop-down list to hide the Zoom Panel.
  4. Right-click + drag to pane the chart (move up, down, left and right) within the container to focus on a particular portion of the chart. 

4_Zoom_Options-min.gif

Note.pngNote: When the Zoom option is enabled, you can also use the mouse wheel to zoom your chart.

Legend

Legend helps you identify and correlate data on your chart. They provide an overview of the different data points involved in the chart along with the colors associated with each of them. Legend consists of Heading and Items.

  1. To turn legends on or off, select the toggle switch next to Legend. 
  2. Select legend position (Left, Right).
  3. Enter text for the legend heading. 
Note.pngNote: Click on legend items and related data will be highlighted in the visualization. 

Container Settings

  1. To show/hide the header and border, click the toggle switch. 
  2. Turn on the toggle switch to show the border for the container. Change the border color, style and width as shown below: 

The following figure displays the effect of various container settings for your Bar chart.

16.png

Visual Interactions

  • Select the target behavior and coordinated visualization scope from the below settings.

mceclip6.png

To learn more, refer to section- ‘Configure Coordinated Visualization’. 

User-Defined Colors

  • Click on the mceclip23.png icon for user-defined colors. 

Colors for Individual Data Item

It lets you add meaning to a data item by associating a specific color to it and differentiate some data items from the rest.

For example, the red and green color may be used to represent “Off Track” and “On Track” issues, respectively. Whereas, orange color may be used for the “Bugs” type of issues to draw attention.

To change the colors:

  1. Click on the mceclip24.png icon next to the data item for which you want to change the color.
  2. Select the color from the available color grid or click ‘More Colors’. 
  3. To restore default settings, click on ‘Reset to Default’.

As shown below, orange color has been added to differentiate that data item from the rest.

18.png

Color Saturation Settings

The following figure shows the default color saturation settings for your visualization.

To customize the color gradient effects:

  1. Select the Minimum and Maximum color.
  2. Toggle ‘Diverging’ option.  An additional color selector for mid-range value, called Center, appears.
  3. Select the color ‘Center’.
  4. You can provide custom values representing ‘Minimum’, ‘Center’, ‘Maximum’ Values. All bars larger than ‘Max Value’ are colored in ‘Max Color’ whereas those less than ‘Min Value’ in ‘Min Color’. 

3_Color_saturation-min.gif

Configuration Options in Full-Screen Mode

Visualization can be seen in full-screen mode by clicking on mceclip25.png icon.

Note.pngNote: Visualizations Panel is not accessible in full-screen mode.
  1. Click on the mceclip26.png icon at the top-right corner of the container.
  2. Select ‘Configure View’ from the overflow menu. 
    23.png
  3. A pop-up form with all the relevant configuration options will appear on the screen.
  4. Configure your visualization and click on ‘APPLY’.
    24.png

 

Related articles

↑