how to generate bar chart to excel.

Ravi gaddam

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Alex Smith12y ago
Hi, Ravi

You may find this page helpful, it presents an example for create bar chart in Excel using C#..All you can do is to follow the program guidance to make bar chart with your own data in table.As you said, the bar chart created by this way will not be image, otherwise the bar chart will be created with nice formatting in Excel file.

Hope it helps you.

Darren Kang12y ago

Hi, try this:

var file = new ExcelFile();
var sheet = file.Worksheets.Add("Sheet1");
 
sheet.Cells["A1"].Value = "Name";
var names = new string[] { "A", "B", "C", "D", "E", "F", "G", "H", "I" };
for (int i = 0; i < names.Length; i++)
    sheet.Cells[i + 1, 0].Value = names[i];
 
sheet.Cells["B1"].Value = "Marks";
foreach (int i in Enumerable.Range(1, 9))
    sheet.Cells[i, 1].Value = i;
 
var chart = (BarChart)sheet.Charts.Add(ChartType.Bar, "D2", "K20");
chart.SelectData("A1:B10", true);
chart.Legend.IsVisible = false;
chart.Axes.Horizontal.NumberFormat = "$#,##0";
 
file.Save("Chart.xlsx");

I hope this is what you are looking for.
Note I used an Excel API from this .NET component and you can use it in ASP.NET applications. Also here you can find another sample of creating a chart element in excel file with C#.