This recipe works for:
SharePoint 2010 Enterprise Edition
SharePoint 2010 Online (Office 365 Edition)
You will need an Excel spreadsheet (containing your data) and a SharePoint site with a document library where you wish to upload your spreadsheet. Excel services will need to be enabled on the server and the document library set as a trusted location (check with your SharePoint administrator if you are unsure about this).
For illustration, I have populated...