how to generate bar chart to excel.

Question

Hi guys,

how to generate bar chart to excel in asp.net with c#.and generated chart should not be as image.

anyway,i have one table having 2 columns .which can be referred in the following text.

Name	Marks
A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8
I	9

bars should be generated for marks.and, name should appeared left side of the y-axis.
In bars generation,maximum value bar should first. x-axis values can be taken until 10.because , 9 is the highest value in the table.one more thing , value should be appeared along with bar edge.appearance of entire chart should be as attached excel document.


generated chart should be as attached excel document.

eventually, what am saying that in the attached file chart pasted as image.hence,i was unable to change the values manually in Excel document.once value will be changed, bars should be sorted out to appropriate place.

if you have any doubts, please let me know.

Thanks
Ravi Gaddam