AJP Excel Information

Create a standard column chart based on the data in A1:B6

Add an duplicate set of data to the chart.
This can be done by either

• Select the range B1:B6 and then drag & drop the data onto the chart

• From the chart menu use Add Data.. and select the range B1:B6

• Use the Source data dialog to add a series and then select the range B1:B6

The reason for using the same data twice is the automatic values used for the scales minimum, maximum, major and minor steps should be the same.

The second set of data is currently displayed next to the original data and is still using the same Y axis.
Double click the original data series and change it so the data is plotted on the Secondary axis.

The only reason for moving the original data to the secondary axis is that the data on the secondary axis is plotted in front of the data on primary axis and it is likely that you might have already formatted the column in terms if fill pattern and borders.

If you require a legend you will have to remove the duplicate data series.