armand149825

Hi,

I am using VSTO to get access to excel charts. It there anyway to have the created charts be displayed in windows form rather than within Excel

When I run my application Excel starts up and my chart is displayed there in a worksheet, but I want the chart to be displayed in a form. And I don't want Excel to be openned at all.

Best Regards,

Armand



Re: Visual Studio Tools for Office Displaying Excel Chart In Windows Forms

Dennis Wallentin

Armand,

In view of Your explicit requirements they require a total different approach.

Instead of using VSTO & Excel You can consider to use the Chart component in Office Web Components (OWC) in a standalone Windows Form's solution. This will require either C# or VB.NET (or VB 6.0)

The free OWC kit is available on the Office CD (OWC11.exe) or You can find it at the following URL:
http://www.microsoft.com/downloads/details.aspx familyid=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

How To Use the Chart Web Component with Visual Basic (VB 6.0 it should not be a problem to port it to VB.NET)
http://support.microsoft.com/kb/235885/EN-US/

Introduction to the OWC Chart Control (VB 6.0 it should not be problem to port it VB.NET
http://www.excelkb.com/article.aspx id=10189&cNode=1U5J4S






Re: Visual Studio Tools for Office Displaying Excel Chart In Windows Forms

Anonymous12321232

you may find the following link is useful:

http://www.codeproject.com/useritems/ExcelCSharp.asp