Re: Chart with Month-Scale, MajorUnitScale

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

  • Re: OT: anger-fest thread
    ...  I know he is trolling with regards to ... I see you have changed your tune with regards to outsider - I did ... he picks on Michael and you jump in. ...
    (alt.support.diabetes)
  • Re: Cannot start Cluster Resources
    ... Regards ... "Michael P. Schieferer" wrote: ... >> we have a 2-Node Cluster here wich running Exchange, File and DHCP ...
    (microsoft.public.windows.server.clustering)
  • Re: putty and SuSE and OpenSSH2 without password
    ... >>> regards ... >>> Michael ... > in the putty-help it should only be no write permissions for group/other. ... William Hooper ...
    (comp.security.ssh)
  • Re: Detecting a dead proxy to a remote object
    ... Michael ... >> calling a method on the proxy? ... >> service itself is the remote object. ... >> Regards, ...
    (microsoft.public.dotnet.framework.remoting)
  • Chart TickMarkUnitType to Week
    ... I group the labels of my chart with TickMarkUnitType and TickLabelUnitType, ... setting both to chAxisUnitWeek. ...
    (microsoft.public.office.developer.web.components)