A secondary value axis (or Line Y-axis) appears when you plot a dual-axis widget (like the Combination Chart containing Columns and Line); a secondary value axis (or Line Y-axis) appears. Many times, the values of data points plotted on the Line Y-axis are very small. They appear when you hover over the column. For this purpose, the Line Y-axis is plotted to make the reading and understanding of the Line values easier.  

For plotting the Combination Chart, you select:

  • One variable to configure X-axis, and
  • One variable each to configure the two Y axes, Column Y-axis, and Line Y-axis.

General settings associated with the Line Y-axis are the same as those for the column Y-axis.



The table given below describes different fields present on General formatting in Y-axis.

Field

Description

Remark

Width

It allows you to select the width of the line used to represent the Y-axis.

By default, the width selected is zero.

Color

It allows you to select the color of the line used to represent the Y-axis.

Scale

It allows you to select the scale in which the variable represented on the Y-axis is plotted

You can select one of the following scale options

  • Linear
  • Logarithmic

Start

It allows you to select the initial coordinate value at the origin from where the Y-axis starts.

  • By default, the setting of the starting coordinate is Auto.
  • The coordinate is selected from the data values that we are plotting.

End

It allows you to select the final coordinate value up to which the variables on Y-axis are plotted.

  • By default, the setting of the ending coordinate is Auto.
  • The coordinate is selected from the data values that we are plotting.

 

To use General formatting options for the Line Y-axis, first plot a Column Chart using the dimensions and measures from the dataset. For example, we plot a Combination Chart of the Count of Limit and Count of Rating against Cards. The Gender and Ethnicity of the sample are the Column and Line Legend, respectively.

The figure given below shows an original image of the Combination Chart. By default,

  • The width of the Line Y-axis is zero; that is, the axis is not visible on the plotted chart.
  • The scale selected is Linear.
  • The starting and ending coordinates on the Line Y-axis are auto selected. In the figure, the starting and ending coordinates of the Line Y-axis are zero (0) and 50, respectively.



Now, change the

  • Width of the Line Y-axis line
  • Color of the Line Y-axis line
  • Starting and Ending coordinates of the Line Y-axis line. Here we choose -5 and 100, respectively.

The resultant widget is shown below



Now, change the

  • Y-axis scale to Logarithmic.
  • Starting and Ending coordinates of the Y-axis line. Here we choose 1 and 150, respectively. [Since log (0) = 1, the logarithmic scale starts from one (1), if the linear scale starts from zero (0).]

The resultant widget is shown below.



(info)

Note:

When you change the Start and End values for the Combination Chart or change the scale, it resizes and adjusts according to the newly selected range. 

Your Rating: