In Excel 2007:
Plot two sets of data on a single chart.
Then, you must select data series you wish to plot on the second axis by either clicking on it on the chart or selecting it from a drop down menu in top left corner under Layout tab. Then click 'Format Selection' under Layout tab and select "Plot on Secondary Axis".
In Excel 2003 and earlier:
Select chart, press Ctrl+1 and proceed with data selection...
Note: that not all charts support this feature.
No comments:
Post a Comment