Please look at:-
Item number 26.
What follows is said in reference to the above file (called secondary_axis).
Take the following action in EXCEL 2007:-
- click somewhere in one of the blue columns (on chart itself)
- this will place blue circles around those columns
- right hand click and select Format Data Series
- Format Data Series pane should launch (and should have Series Options
highlighted in the top left hand corner)
- select the Secondary Axis radio button towards the bottom of the screen
Please hit Yes if my comments have helped.
In Excel 2007 from the Series Options
I only have the following options: Gap
What am I doing