This chart is not clear as it is not showing the sales percentage clearly. To show the sales in a graphical form, we need to plot a column chart first. The second method is using a column chart.
Now the chart can be seen with two axes as per the below image.
The first step is to select the graph type directly from Insert > Combo and select the “Clustered column-Line on secondary axis” as shown below. There are some steps to add a secondary axis. The secondary axis is based on a column chart. The data has “Month” in the first column, “Sales” and “Sales percentage” in the second and third column, respectively. We’ll use the above table to demonstrate the addition of a secondary axis in the chart. Below are the steps to add a secondary axis to an existing chart. 
Representation of the two data sets in a single chart usually helps in better visualization from a reader as well as an analyst’s point of view. This type of technique is often used in the financial model where we need a clear picture of the data. If both the data sets are important to show, we can use a secondary axis. This is the most advanced technique used in analytics to show two data sets in the same graph. While creating a secondary axis, the result is both axes vertically shown on the same graph. Both the data sets are on Y-axis, but the second data set is added as a secondary axis to the same chart. Sales amounts are shown in blue bars, whereas Targets are shown in the orange line represented in the vertical axis as shown above. When a secondary axis is added, the graph will look like this, as shown below. This data has two datasets I,e Sales and Target Achieved %. Excel for mac line chart add secondary axis download#
You can download this Add a Secondary Axis Excel Template here – Add a Secondary Axis Excel Template
0 kommentar(er)
