Its pretty easy. These instructions are from Excel Help:
Select the cells that contain the data that you want to appear in the chart.
If you want the column and row labels to appear in the chart, include the cells that contain them in the selection.
Click Chart Wizard .
Follow the instructions in the Chart Wizard.
You can email me the spreadsheet if you get stuck.
paul.hone@orange.net