Re: Chart with Month-Scale, MajorUnitScale

Hello!

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

Regards
Michael

"Alvin Bruney - ASP.NET MVP" <www.lulu.com/owc> schrieb im Newsbeitrag
news:e4v4zgTIGHA.3728@xxxxxxxxxxxxxxxxxxxxxxx
> 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" <abc> wrote in message
> news:##eycJTIGHA.604@xxxxxxxxxxxxxxxxxxxxxxx
>> 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
>>
>>
>
>


.

Relevant Pages
Loading