How add live charts in Excel while using xmlns

See more:

MS-Excel

Hello,

I was generating excel using Xmlns in C#. Using that I am able to generate the table with full of data. But now I am facing difficulties to generate Live chart from those data.

<Worksheet ss.Gridlines=\"0\" ss:Name=\"Sheet Name\">
<Table>\r\n<ss:Column ss:Width=\"150\"/>
<Row><Cell ss:MergeAcross=\"14\" ss:StyleID=\"sHeader\"><Data ss:Type=\"String\">Header</Data></Cell></Row>
<Row><Cell ss:MergeAcross=\"14\" ss:StyleID=\"s62H\"  ><Data ss:Type=\"String\">data 1</Data></Cell></Row>
<Row><Cell ss:MergeAcross=\"14\" ss:StyleID=\"s62H\" ><Data ss:Type=\"String\">data 2</Data></Cell></Row>
</Table>
</Worksheet>

Though in this code I have only 1 column. But consider it as a table to generate the chart. Searched in Google but didn't get any suitable solution. Can any one kindly help me out of this problem...

Thanks