Column Chart

Column Chart

A column chart is a method of displaying data with categories represented by a rectangle sometimes called vertical bar charts. They allow easy comparisons among a number of items and trend analysis.

How to Create a Column Chart:

• First, you need to go to Visualization Section in Reports V2 and select the Column Chart option.

• Now in the Build panel go to the X-axis section and Choose or Drop the desired Dimension column(Date or Categorical column).

For eg: You need to create a "Region-wise Revenue Report" and then you need to select the "Region" column in the X-axis section.

• Now in the Y-Axis section, you need to select the relevant Measure columns with desired Aggregation functions such as Sum of Sales, Count of Orders, etc wrt which you want to plot the Column Chart.

• Then Click on the Run Button and your Column Chart will be ready.

In Report V2 Column Chart has two panels Build and Format.

Build

This panel is like a building block for the Column Chart. It allows you to select various Dimension and Measure columns for creating the Column Chart.

It is further divided into 3 parts:

Chart Settings: This allows you to select the relevant Dimension and Measure Columns.

• X-Axis: Here you can select only 1 Dimension Column (Date or Categorical) against which you need to plot the Column Chart in X axis.

• Y-Axis: Here you can select 1 or more Measure Columns using which you will plot vertical columns in the Column Chart.

• Category: Here you can select any 1 dimension column to further divide the Column Chart into different subcategories each with their separate vertical columns or bars.

For eg: You have created a "Region Wise Number of Orders" report and now you want to further divide this report to see how two genders Male/Female have contributed in the same then you can easily achieve that by selecting the "Gender" column in the Category section and Click on the Run Button. You will now have an updated Column Chart showcasing the "Region Wise Number of Orders" along with the Gender wise division for each region represented by separate columns.

Row Limit: This allows you to limit the Output rows by going to the Row Limit section in the Build panel then selecting the number of rows and clicking on the Run Button.

Sort: This allows you to Sort the report based on certain columns. Go to the Sort option at the bottom in the Build panel then choose one or more columns along with the order Ascending or Descending and then click on the Run button.

Format

This panel allows you to apply various formatting techniques on the Column Chart to make it more customized as per your need. It consists of various different sections which are as follows:

Title

This allows you to give a Title to the Line Chart. You just need to go to the Title section in the Format panel.

You can easily toggle it on or off. In the "Customize title" modal, you can:

• Modify the title text, font size, and alignment, and even add a background color.

• Include an optional description that will appear when hovering over the "i" icon that will be visible as a floating button on the tile.

Once done, click the Apply button.

Legend

• This allows you to showcase the chart legend.

• By default it is disabled. But you can easily enable it by clicking on the Show Legend toggle button under the legends section under the format panel.

• Choose from a variety of positions, including top, bottom, left, and right, with options for stacking and centering.

• For charts with many legends, you can now paginate them or arrange them in multiple rows.

• Additionally, you can customize the font size, color, family, and style of legend text to match your chart's design.

X-Axis: This allows you to name the X-axis and showcase the axis labels in Column Chart. It has the following components:

• Name: Here you can give the name for the X-axis in the Column Chart.

• Name Gap: This allows you to decide how far below the X-axis the name should appear.

• Name Label: This allows you to decide the format of the name given to the X-axis like font size, font type, font family, etc.

• Axis Label: This allows you to enable/ disable the axis labels in the Column chart. By default it is disabled and you can easily enable it by clicking on the Show toggle button and then choosing the relevant font format for the axis labels to be displayed in the Column chart.

Y-Axis: This allows you to name the Y-axis and showcase the axis labels in Column Chart. It has the following components:

• Name: Here you can give the name for the Y-axis in the Column Chart.

• Name Gap: This allows you to decide how far left the Y-axis the name should appear.

• Scale: It allows you to choose the Y-axis scale as per your requirement and data values. You can choose either a Linear or a Logarithmic scale.

• Scale Start: Here you need to select the starting point for the Y-axis scale.

• Scale End: Here you need to select the end point of Y axis scale.

• Position: Here you can choose the position of the Y-axis like whether you want to show the Y-axis scale on LHS or RHS.

• Name Label: This allows you to decide the format of the name given to the Y axis like font size, font type, font family, etc.

• Axis Label: This allows you to enable/ disable the Y-axis labels in the Column chart. By default it is disabled and you can easily enable it by clicking on the Show toggle button and then choosing the relevant font format for the axis labels to be displayed in the Column chart.

Data Colors: It allows you to select the desired color for showcasing the vertical columns( data points) in the Column Chart as per your need.

By default, it will be Blue and you can change it by clicking on the Data Colors section in the Format panel then choosing the measure column for which you want to change the color, and finally selecting the color and clicking on Apply button.

Labels

It allows you to enable/disable the visibility, the appearance & the layout of data labels. By default, it will be disabled. You can turn on the labels using the toggle switch.

Global settings

Global Label Settings

Apply consistent formatting to all labels within a chart.

You can customize:

• Layout: Position, alignment, overflow, and rotation etc.

• Content: Display values, series names, or categories.

• Appearance: Font, color, background, and number formatting etc.

Specific Settings

Specific Label Settings

Tailor labels for individual data points or categories.

Ideal for highlighting specific data or creating visual distinctions.

To add specific formatting:

• Add the specific label from the dropdown

• Click on the fields to make them editable and change the values according to your requirements.

• Apply the changes. These changes will override the global settings.

Example: Display percentages as labels for one series, while showing values for another.

Stack: It allows you to enable/disable the stacking of various Columns over each other in the Column Chart resulting in a Stacked Column chart.

Data Zoom: It allows you to zoom in/out the report output as per your need. It is disabled by default so you need to enable it first if you need to zoom in on your report.

It has the following components:

• Slider: It allows you a slider functionality using which you can scroll through the zoomed-in version of your report(Column Chart). If it is not enabled then you can only view a static zoomed-in part of your report output.

• Start %: It allows you to set the starting point of your Column Chart report from where you want to zoom in.

• End %: It allows you to set the end point of your Column Chart report up to which you want to zoom in.

Grid Offset: It allows you to adjust the chart grid as per your need. It has 4 offset types: Right,Left, Top, and Bottom.

Filed Formatting: This allows you to format field values in any Column as per your requirement. It involves changing the field value's display units, the number of decimal places, any prefix or suffix, etc.

Gridlines

Here you can configure the appearance of the horizontal gridlines in the background of the chart separating the cells. You can:

• Choose to show or hide it using the toggle their toggle switch.

• Also, configure the line width and the color of the lines.