Arranging secondary axis
In one of the earlier texts there were words on how to take advantage of the secondary axes to display disproportionate data series. The common problem here is the overlapping of the series. Therefore, the data is not sufficiently noticeable. By adjusting the width and gap between the series it can be slightly corrected. However, in order to make the data on the graph more noticeable, one can use a trick that will be described in the following text …
Editing the data on the secondary axis will be shown on a simple example. A table has been created with five companies that in two columns contain data on income and number of employees in these companies. If, on the basis of this table, a chart with the series presented in the columns is made, then it is modified so that the amount of income is shown on the primary, and the number of employees on the secondary axis, it would look like the following figure.
As you can easily see, the series overlap. How to split the series so that the number of employees is separate from the income of the company? The answer is: by introducing artificial, “empty” values within the data series. In our example, we will do this by placing an empty cell in the first column after each of the value for revenue. We will do the same for a column with the number of employees, only we insert empty cells so that they are “moved” for one field. The aim of such a series change is that, whenever we have the value in the revenue column, it corroborates the empty value in the employee column and vice versa. After this operation, you need to click on the Design ribbon and choose the Select Data option to change the range of cells from where the data for displaying the data series in the chart is downloaded. The cell range should include values and empty cells. Also, the size of the range for both data sets should be the same. If we did everything properly, we’ll get a graph that clearly separates the series that appear on the primary one from those represented on the secondary axis.