Showing your company revenues and return-on-investment percentage in single plot
How do you add a second y-axis to the right of your figure in Excel? Consider the following example of Incomes in thousands and gain as a percentage and you want to show it as follows. If you plot them on the same y-axis, "Gain" will not be recognizable. The solution is to plot 'Gain' on a secondary y-axis. The steps are as follow: 1. Select all your data 2. Click 'Insert' from the menu and select your chart type (eg, bar, line, scatter) 3. Right-click on the line you want to show it in the secondary y-axis (Gain in our example) 4. Choose 'Format Data Series' from the open drop menu. The 'Format Data Series' menu will open on the right of your Excel sheet see below. 5. Choose from under "Series Options" plot series on the "Secondary Axis". 6. If you want to show "Incomes" as bar chart then right-click on the blue line and select ''Change Series Type". A new window will open as follows. Click th...