Using Excel (VBA) to create a Chart Control in Excel or Web Page??


I need to create a chart to display data from an Excel report. The report is drawing the data from SQL using vba in the back ground.

Can you point me in the direction of some sample vba code to create a chart control in Excel?

Also, can anyone comment on the benefits of displaying the chart in either Excel or as a Web Page??

Many thanks,

Who is Participating?
ericathomeConnect With a Mentor Commented:
Sample code and instructions are available at the links below. Deciding on Excel parts vs. ASP.NET or Silverlight depends on your audience, goals, and infrastructure available. If you have a server supporting the .NET framework 3.5 sp1 for ASP.NET or Silverlight, that is a better solution in many ways than an Excel spreadsheet or Excel plugin in a web site. If you need a portable solution where a server is not available, then a spreadsheet may be a good solution.

Excel plugin on a website: 

ASP.NET examples and resources: 

Silverlight chart example: 

Let me know if you need something more specific.

Thanks, Eric
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.