(Last Updated On: November 30, 2022)

The Column chart is one of the 10 major chart types ActivePresenter 9 offers. It is best suited when you want to illustrate data changes over time or comparisons among items or categories. Let’s explore how to work with column charts further!

In ActivePresenter 9, a Column chart presents data in rectangular vertical bars whose heights are proportional to the values. In which, categories are distributed on the horizontal axis while values are organized on the vertical axis. 

Let’s start out with the following simple data set: 

Data example-column chart

Suppose that you want to compare the total units sold of three commodities, namely Coffee, Milk, and Tea, broken down by financial quarters. The data can be visualized using a Column chart without any effort in ActivePresenter 9.

Download the app below and explore!
Download ActivePresenter

Today’s tutorial will walk you through 5 main parts:

  1. Insert Column Charts
  2. Edit Data for Column Charts
  3. Change Column Chart’s Styles
  4. Adjust Chart Layout
  5. Preview and Export Column Charts

Insert Column Charts

To insert a Column chart, take the following steps:

Step 1: Click the Insert tab > Chart

Step 2: In the Insert Chart dialog that appears, click the Column chart type on the left pane. 

Insert column chart

At the top of the dialog, you can see there are 2 available variations of the Column chart. They are Column and Stacked Column in turn. 

2 Column chart types
  • Column: Compares individual data values in the same category or across categories and displays them vertically.
  • Stacked Column: Compares the total of data values across categories as well as shows the relative contribution of each data value to the total by displaying values in vertical stacks.

Step 3: Choose either of the two variations. Otherwise, you can switch to the other type later. 

Step 4: Click OK to insert.

Edit Data for Column Charts

After inserting a chart, you are free to edit the default data values in the Chart Data window that pops up. 

Default chart data

Note: When you select the chart, this window should be shown up. If not, you can right-click the chart > select Edit Chart Data.

Working with chart data is quite similar to working with cells in Excel spreadsheets. Now you need to replace the defaults with your data:

  • Select the Dataset cells and change texts to Coffee, Milk, and Tea respectively.
  • Change texts in the Category cells into 4 Quarters, similarly.
  • Select the value cells and enter your data values.

Note: You are free to add or delete any Dataset and/or Category as you want. For other detailed manipulations, please refer to the Edit Chart Data section in this tutorial.

After that, you will see all the changes are reflected in the chart immediately. 

Your chart should look like this: 

Chart output-column chart

Change Column Charts’ Styles

If the default chart styles do not satisfy you, you can access the chart Properties pane > Chart > Style. There are several options for chart-style customizations. 

First of all, let’s distinguish some elements available on the Column chart. This will give you a better understanding of elements to be customized later.

Elements on Column charts

Note: Some elements are not shown by default. You can select the chart > click on the plus button > choose to show or hide any elements. 

The Style section (Chart tab > Style) in the Properties pane allows you to customize the background fill and line of the datasets, as well as gridlines, tick labels, and axis labels. 

Customize Datasets

The Dataset means data values presented in colored vertical bars. Click the drop-down Dataset list to switch to any dataset you want to customize. 

Dataset section-column chart
  • Fill and Line: Fill the dataset and its line border with a single color, respectively. 
  • Plot Dataset On: Choose between Primary Axis and Secondary Axis to plot a dataset on. In the Column chart, the primary axis runs along the left side of the chart and the secondary axis runs along the right side. You can use a secondary axis when the data values vary greatly between one another without the need for additional charts.

Note: You cannot plot all the datasets in the secondary axis. 

For example, in the chart below, the Coffee dataset (blue-colored) is plotted on the Secondary axis while the others are plotted on the Primary axis. 

Secondary axis

Customize Scale Options

In this section, feel free to adjust the gridlines, tick labels, and axis labels corresponding to the axis that the dataset is plotted on. 

Click the drop-down Axis list to choose one of the chart axes to customize its properties. There are four types of axes: Primary Horizontal, Primary Vertical, Secondary Horizontal, and Secondary Vertical

Note: The properties for the Secondary Horizontal and Secondary Vertical options are only available when you plot at least one dataset on the Secondary axis. 

Gridlines 

Customize gridlines

Gridlines are lines that cross the chart area to indicate the divisions on the axes. You can choose to draw gridlines of the currently selected axis with a single color or not. Adjust the transparency and the width of the gridlines the way you want.

  • Dash Pattern: Change the pattern of gridlines, either Solid or Dash.
  • Draw On Chart Area: Tick the checkbox to draw horizontal/vertical gridlines on the chart area. Drawing gridlines helps viewers understand what values are represented by unlabeled data points.
Draw on chart area

Note: Since the Column chart is a vertically-oriented chart, there are no Secondary Vertical gridlines. 

  • Draw Tick Mark: Tick the checkbox to draw lines which are the extension of the gridlines from the axis border to the tick labels.
Draw tick marks
  • Draw Border: Tick the checkbox to draw a line border at the edge intersecting with the corresponding axis.
Draw border

Tick Labels

Customize tick labels

Fill the tick labels of the corresponding axis with a single color. You can also change the font name, font size, and make the tick labels bold and/or italic the way you want. Otherwise, if you want the axis to have no tick labels, just select Text No Fill

Axis Label

Customize axis label

Fill the axis label of the corresponding axis with a single color. Enter a new name of the axis label in the Text field. Moreover, change the font name, font size, bold, and/or italicize the axis label as your like. If you don’t want to show the axis label, select Text No Fill

Note: The Secondary Horizontal axis has no tick labels and axis label. 

Adjust Chart Layout

Chances are you want to re-organize the chart layout, you can do that with ease. The whole chart has the Flex layout by default. You can adjust the chart layout in the chart Properties pane > Size & Properties > Container Layout

Adjust container layout

Besides, since the chart parts are snapped to the Flex layout, you cannot adjust them manually. Instead, just select each chart part then customize it in the Properties pane > Size & Properties > Flex Child

Once you’ve done customizing the chart, the result should be somehow as follows:

Customized Column chart

Preview and Export Column Charts

It’s great if viewers can see the data labels in the output. Fortunately, ActivePresenter 9 allows you to do that. In the HTML5 output, viewers can hover the mouse over the datasets to see the data values. Let’s see:

Data values in the HTML5

So now you know how to work with the Column charts in ActivePresenter 9. Why don’t you try this feature right now? Give the app a go and see the benefits it can bring to your work. Moreover, feel free to ask us if you need any help. 

Related articles

Introduction to Charts
Polar Area Charts
Pie Charts