custom chart in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christian Hansen - 24 May 2006 10:07 GMT

Hi NG,

I want to create a custom chart type in Excel. Can this be done using VSTO? Can someone perhaps provide a link, where I can find
informations about this issue? I googled a lot but I found nothing...

Thanks,
Christian

Reply to this Message

Alvin Bruney - 25 May 2006 02:01 GMT

Have a look at the chart wizard object if you intend to bind the chart to a
spreadsheet object. For stand alone charts, you can make use of the chart
object. Either way, the chart needs to be bound to an Excel spreadsheet as
its datasource. There is a chapter in my latest book dedicated to charting
with vsto.

Signature

________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------

> Hi NG,
>
[quoted text clipped - 4 lines]
> Thanks,
> Christian

Reply to this Message

Christian Hansen - 26 May 2006 08:37 GMT

Hi,

thank you for your reply, but this was not excactly what I wanted to know. I really want to create a new type of chart. Other user
should be able to use this charttype as well. The chart should look like a thermometer, based on data in the spreadsheet. I think it
will work by using a com-addin, but I do not really get any further.

Best regards,
Christian

> Have a look at the chart wizard object if you intend to bind the chart to a spreadsheet object. For stand alone charts, you can
> make use of the chart object. Either way, the chart needs to be bound to an Excel spreadsheet as its datasource. There is a
[quoted text clipped - 7 lines]
>> Thanks,
>> Christian

Reply to this Message

custom chart in Excel

Free Magazines