Data Analysis with Excel

Consider having the following raw data (on the left). How do you plot the average monthly salary of your employees based on gender, age, and function (plot on the right)? See the steps below. 1. You need to categorize your raw data into the following table:. To do that:      a. S ort your data according to age from smallest to largest,      b. Use pivot-table for each range of age (eg, 20-30, 30-40, etc.),       c. Copy and paste the averages into the table.    2. Select the previous table as a whole and click "Insert" from the menu. You may choose the bar chart to get the following plot: NB. To add a secondary axis to this plot see  Add-second-y-axis-to-right-of.html

 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...