The series for a chart must be static, and more than one series must exist if you want to create a dual axis chart. When you are setting up your chart, set series to static and select more than one series. Then access the Format Chart Series window to set the axis for each series.