Skip to content

Customizing your ViewChart

There are three sections in chart properties, Common, Default Series, Axes and Other Series.  These three sections control specific behaviours of the Chart, the common properties, the default series properties and the Axes and Other Series properties.

Common Properties

The common properties section allows you to control the following:

Title

Toggle whether you want to show a title on your chart

Text

The text that you want to show as your title

Alignment

The position and alignment for your title in two sets:

  • Vertical
  • Top
  • Bottom
  • Horizontal
  • Left
  • Middle
  • Right

Title Colour

The colour of the title text

Legend

Toggle whether or not to show a legend on the chart

Alignment

The alignment of the legend with the following options:

  • Top Centre
  • Left Middle
  • Bottom Centre
  • Right Middle

Drillable

Toggle whether or not the users of the chart can drill down.

Animations

Toggle whether or not to show the chart animating from one state to another

Tooltips

Toggle whether or not to show tooltips over the charts data points

Theme

The preset colour theme for your chart

Default Series Properties

These properties allow you to specify a chart type as well as specific series formatting for the default series.  This is always the left most column in your data.

Chart Type

Select the type of chart you want to display from the following options:

  • Column
  • Bar
  • Line
  • Area
  • Pie
  • Dognut
  • Funnel
  • Bubble
  • Waterfall (Horizontal)
  • Waterfall (Vertical)

Axis Position

Which value axis will this series plot against, one of:

  • Primary (left)
  • Secondary (right)

Series Colour

The colour this series will show on your chart

Labels

Toggle whether or not to show series labels

Format

Set a number format on the labels. For more information on formating, see Date Formatting and Number Formatting

Position

Set the position of the labels against the data point. This is different for the different chart types and could be one of:

  • Above
  • Below
  • Bottom
  • Center
  • InsideBase
  • InsideEnd
  • Left
  • OutsideEnd
  • Right
  • Top

Label Colour

The text colour of the labels

Specific for Chart Type:  Column, Bar

Gap

Toggle whether you want to show a title on your chart

Spacing

Allows you to set the distance between series points in a category expressed as a percentage of the bar width

Specific for Chart Type:  Column, Bar, Line, Area

Stacked

Toggle whether you want to show you data as a stack

Stacked 100%

Toggle whether to show the data points as a percentage against the total for the category

Specific for Chart Type:  Funnel

Dynamic Height

Toggle whether you want to show the funnel chart with a dynamic or static height. When dynamic, the size of each part of the funnel will be relative to the size of the data for that data point

Dynamic Slope

Toggle whether you set to true the ratio of the bases of each segment is calculated based on the ratio of currentDataItem.value/nextDataItem.value The last element is always created like a rectangle since there is no following element

Neck Rato

Specifies the ratio top-base/bottom-base of the whole chart. For example. a Neck Ratio set to three means the top base is three times smaller than the bottom base

Spacing

Allows you to set the distance between series points in a category expressed as a percentage of the width

Specific for Chart Type:  Waterfall

Gap

Allows you to set the distance between categories expressed as a percentage of the bar width

Reverse Sign

Toggle whether you want to reverse the sign of the data being shown

Start Colour

The colour of the first bar in the waterfall chart

Up Colour

The colour of the bars that move upwards in the waterfall chart

Down Colour

The colour of the bars that move downwards in the waterfall chart

Other Colour

The colour of the bar that represents the other bar, which will show as the penultimate bar and will make up the difference between the first bar, plus the movements, minus the last bar.

End Colour

The colour of the last bar in the waterfall chart

Column / Bar Properties

Line and Area Properties

Pie and Dognut Properties

Funnel Properties

Bubble Properties

Waterfall Properties

Axes and Other Series

This section has three parts, Other Series properties, Value Axis properties and Category Axis properties.

Value Axis

The Value Axis can have a Primary and Secondary set of properties configured depending on the chart type and whether or not you are plotting any of your series on the secondary axis.  The properties are the same for both axes.

Title

Toggle whether you want to show a title on your chart

Text

The text that you want to show as your title

Alignment

The position and alignment for your title in two sets:

  • Vertical
  • Top
  • Bottom
  • Horizontal
  • Left
  • Middle
  • Right

Title Colour

The colour of the title text

Labels

Toggle whether or not to show series labels

Format

Set a number format on the labels. For more information on formating, see Date Formatting and Number Formatting

Position

Set the position of the labels against the data point. This is different for the different chart types and could be one of:

  • Above
  • Below
  • Bottom
  • Center
  • InsideBase
  • InsideEnd
  • Left
  • OutsideEnd
  • Right
  • Top

Label Colour

The text colour of the labels

Min

Toggle whether you are going to set a minimum for the chart. The minimum can be expressed as an exact number or a percentage (decimal between 0 and 1) For example, if you are building a Waterfall chart and you want to make sure there is as much room as possible, you may set the minimum to something like 0.05 (5%) so that the distance from the lowest point to the chart category is 5% less than the smallest number.

Max

Toggle whether you are going to set a maximum for the chart. The minimum can be expressed as an exact number or a percentage (decimal between 0 and 1) For example, if you are building a Waterfall chart and you want to make sure there is as much room as possible, you may set the maximum to something like 0.05 (5%) so that the distance from the highest point to top of the chart is 5% more than the largest number.

Major Grid

Toggle whether or not to show the major grid lines. These are the lines that are an extension of the major ticks through the body of the chart.

Minor Grid

Toggle whether or not to show the minor grid lines. These are the lines that are an extension of the minor ticks through the body of the chart.

Major Ticks

Toggle whether or not to show the major tick marks on the axis

Minor Ticks

Toggle whether or not to show the minor tick marks on the axis

Category Axis

The Category Axis is generally the horizontal axis

Title

Toggle whether you want to show a title on your chart

Text

The text that you want to show as your title

Alignment

The position and alignment for your title in two sets:

  • Vertical
  • Top
  • Bottom
  • Horizontal
  • Left
  • Middle
  • Right

Title Colour

The colour of the title text

Labels

Toggle whether or not to show series labels

Format

Set a number format on the labels. For more information on formating, see Date Formatting and Number Formatting

Position

Set the position of the labels against the data point. This is different for the different chart types and could be one of:

  • Above
  • Below
  • Bottom
  • Center
  • InsideBase
  • InsideEnd
  • Left
  • OutsideEnd
  • Right
  • Top

Label Colour

The text colour of the labels

Major Grid

Toggle whether or not to show the major grid lines. These are the lines that are an extension of the major ticks through the body of the chart.

Minor Grid

Toggle whether or not to show the minor grid lines. These are the lines that are an extension of the minor ticks through the body of the chart.

Major Ticks

Toggle whether or not to show the major tick marks on the axis

Minor Ticks

Toggle whether or not to show the minor tick marks on the axis

Other Series

In this section, you will see a collapsed section for each series detected in your data (your columns). By default, they are toggled to inherit the properties from the default series as above, but you can disable this inheritance by using the toggle button on the right end of each series heading.  The first image to the right shows the properties for November as not inherited and the properties December as inherited.

The properties you can set on the series are the same as the default series except for the chart types you can set as there are certain chart types that can not go together, for example a Bar and a Pie.