URGENT (Please help) : Bloxplots in Excel

[Nader]

Hello,

I'm trying to create a bloxplot by using the ChartSpace Control in OWC10
(I'm coding in VBA). The only problem I've got is that I can't find a few
functions that exist with ActiveChart in Excel. The functions are :
".HasHiLoLines", ".HasUpDownBars" and ".AxisBetweenCategories". Can someone
tell me what are the equivalent of those functions, please ?

Thanks

Nader

 

[Alvin Bruney [MVP]]

There is no equivalent. That functionality doesn't exist. However, you can
build it in using custom drawing. Here's a link to custom
drawing.http://support.microsoft.com/default.aspx?scid=kb;en-us;555162

--
________________________
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

 

[Nader]

Thanks Alvin.

There is no equivalent. That functionality doesn't exist. However, you can
build it in using custom drawing. Here's a link to custom
drawing.http://support.microsoft.com/default.aspx?scid=kb;en-us;555162

--
________________________
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
-------------------------------------------------------

Hello,

I'm trying to create a bloxplot by using the ChartSpace Control in OWC10
(I'm coding in VBA). The only problem I've got is that I can't find a few
functions that exist with ActiveChart in Excel. The functions are :
".HasHiLoLines", ".HasUpDownBars" and ".AxisBetweenCategories". Can
someone tell me what are the equivalent of those functions, please ?

Thanks

Nader