Excel Web Parts in sharepoint 2010

Step 1) Create new Page in Sharepoint site. name it as ExcelDemo.aspx
Step 2)  Create new Excel Sheet & upload it to Shared-Document Library

         
Step 3)  Select Sales man data & name it as "SalesDetails"(shown above)
Step 4) In Excel Sheet, Insert Bar Graph  for sales man details.  By default Chart has Name "Chart 1"

Step 5) Now goto ExcelDemo.aspx page --> Edit mode --> Insert 2 Webpart
            1 Excel Web Access  for salesmandetails pivot table
             second one for graph i.e chart 1

Step 6) After inserting 2 excel web parts, the page(ExcelDemo.aspx) will look like this

Step 7)  Now click on "Click here to open tool pane"

Step 8)   Now select  Sales-data.xlsx  located in Shared-Documents
             and in the  Named Items type "Chart 1"  as shown below

Click OK in first excel webpart

Repeat the samething for second webpart
                               in the "named Item"  type  "SalesDetails"--> Click OK

Now OUTPUT will look like this.