Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm writing a console application that fetches data from database (SQL) and writes to an excel sheet. Now I want to add a chart in the workbook according to the datatable values. How can I create chart in the sheet before saving? How will I use dataset values to create chart?

Thank you.

share|improve this question
This looks more lika a programming question then a DBA question, you should ask on stackoverflow instead of dba.SE – Daniel Serodio Aug 10 '12 at 18:05
I believe this question is in intersection between programming and business intelligence. BI questions are welcome here. These question is equally applicable to stackoverflow – Atilla Ozgur Aug 10 '12 at 21:28

If you are using csv , you can not do this. But if you are willing to use other tools like Microsoft SQL Server Reporting Services or Crystal Reports you may do this.

If you can not install Reporting Services Server or do not want to, you can still use it for basic reporting purposes. Take a look at here,Microsoft Reporting without SQL Server Reporting Services.

Note that , I gave you examples for reporting services since it is easy to use out of box and in most cases free. But there are a lot of other tools exists which may be more suitable/powerful for your use case.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.