title: SharePoint - Chart Web Part Data from 2 Excel worksheets
body: <p>I am new to SharePoint and I am now making some pages for my users.</p>
  
  <p>My company is using SharePoint 2010 Enterprise.</p>
  
  <p>I would like to add a chart web part into one of the site pages.</p>
  
  <p>I choose Excel as the source of data, so far I got no problem, however,as the data required by the chart is separated into 2 different worksheets in the same workbook. I can only use one of the worksheets data to act as the source of data.</p>
  
  <p>So, here's the question, how can I input 2 or more worksheets for the "range name"?</p>
  
  <p>Please advice what I can do.</p>