Embedding a Google Spreadsheet Chart in a Google Site is very straightforward.
From the Sites editor select Insert>Chart , select the spreadsheet containing the chart, select the chart required, set the gadget properties and save.
Chart from OLD spreadsheet
Chart from NEW spreadsheet