#import  "C:\Program Files\Common Files\System\ado\msado21.tlb"  \
       rename( "EOF" ,  "MSADO21_EOF" ) 
#import  "C:\WINDOWS\System32\msdatsrc.tlb" 
#import  "C:\WINDOWS\System32\MSCOMCTL.OCX"  \
       rename( "ExtractIcon" ,  "MSCOMCTL_ExtractIcon" ) 
#import  "C:\Program Files\Common Files\Microsoft Shared\Web Components\10 \OWC10.DLL"  
 //...
OWC10::ChChartSpace* ChChSpace_;
//...
HRESULT hr = GetDlgControl(IDC_CHARTSPACE, __uuidof(OWC10::ChChartSpace), 
       (void**)&ChChSpace_);
ATLASSERT(hr == S_OK);
// ...
ChChSpace_->put_ConnectionString(_bstr_t( "Provider=MSDASQL.1 ;
       Persist Security Info=False;Data Source=ATLCHARTXLSDATA;PASSWORD=;"));
ChChSpace_->put_CommandText(_bstr_t( "SELECT `Sheet1$`.F1, `Sheet1$`.F2
       FROM `D:\CODE\TRIAL\ATL_CHART\data`.`Sheet1$``Sheet1$`" ));

OWC10::ChCharts* ChartsPtr = NULL;
ChChSpace_->get_Charts(&ChartsPtr);
OWC10::ChChart* ChartPtr = NULL;
ChartsPtr->get_Item(_variant_t( 0 ), &ChartPtr);

ChartPtr->SetData(OWC10::chDimCategories, OWC10::chDataBound, 
     _variant_t(_bstr_t( "F1" )));
ChartPtr->SetData(OWC10::chDimValues, OWC10::chDataBound, 
      _variant_t(_bstr_t( "F2" )));