Chart with Month-Scale, MajorUnitScale

[Michael Popp]

Hello!

I have an OWC 11 chart (chChartTypeLine) in Visual Basic .NET 2003 with date
values on the x-axis and decimal values on the y-axis (it's a share price
chart). On the scale of the x-axis, I would like to show only the months. In
Excel 2003, this works fine with
Axes(xlCategory).MajorUnitScale = xlMonths
The OCW chart doesn't have this property. So I have tried GroupingUnitType =
chAxisUnitMonth. But grouping seems to really group all the values of each
month, showing only one single value per month (min, max, average, what
ever). Of course the graph should still show every single day point.
Can you give me a hint if Excel's MajorUnitScale ist still available in OCW
or how I could get my result otherwise?

Thanks
Michael

 

[Alvin Bruney - ASP.NET MVP]

use a numberformat on the axis
..numberformat = "MM" should give you the months printed out

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[Michael Popp]

Hello!

I've found my properties! They are TickMarkUnitType, TickMarkSpacing,
TickLabelUnitType and TickLabelSpacing!

Regards
Michael

use a numberformat on the axis
.numberformat = "MM" should give you the months printed out

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Hello!

I have an OWC 11 chart (chChartTypeLine) in Visual Basic .NET 2003 with date
values on the x-axis and decimal values on the y-axis (it's a share price
chart). On the scale of the x-axis, I would like to show only the months. In
Excel 2003, this works fine with
Axes(xlCategory).MajorUnitScale = xlMonths
The OCW chart doesn't have this property. So I have tried
GroupingUnitType =
chAxisUnitMonth. But grouping seems to really group all the values of
each
month, showing only one single value per month (min, max, average, what
ever). Of course the graph should still show every single day point.
Can you give me a hint if Excel's MajorUnitScale ist still available in OCW
or how I could get my result otherwise?

Thanks
Michael