OWX x-Axis

[the G]

I've got the following properties set for the x-axis of a line graph
Set objAxis = loGraph.Axes(oConst.chAxisPositionBottom)

'Axis Properties
With objAxis
.HasTitle = True
.Title.Caption = "Time"
.Font.Size = 2
End With
The problem is, it's reading 100s of lines in from a file and plotting the graph, and trying to output the time for each entry!
Is there a way of reducing the x-axis labels so it would show hourly (for example)
11:00 12:00 13:00
rather than trying to fit everything in between in also! (believe it or not the entries are at 10 second intervals!)

I don't want to lose the values in between though.

 

[the G]

It would be handy if I could spell also!!!

OWC x-Axis!!!!!!!!!!!!!!!!

Also, I'm using vbscript to generate the graph from a csv file
I've got the following properties set for the x-axis of a line graph
Set objAxis = loGraph.Axes(oConst.chAxisPositionBottom)

'Axis Properties
With objAxis
.HasTitle = True
.Title.Caption = "Time"
.Font.Size = 2
End With
The problem is, it's reading 100s of lines in from a file and plotting the graph, and trying to output the time for each entry!
Is there a way of reducing the x-axis labels so it would show hourly (for example)
11:00 12:00 13:00
rather than trying to fit everything in between in also! (believe it or not the entries are at 10 second intervals!)

I don't want to lose the values in between though.

 

[Alvin Bruney - ASP.NET MVP]

Have a look at the tickmark object, it should give you what you want.

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



It would be handy if I could spell also!!!

OWC x-Axis!!!!!!!!!!!!!!!!

Also, I'm using vbscript to generate the graph from a csv file
I've got the following properties set for the x-axis of a line graph
Set objAxis = loGraph.Axes(oConst.chAxisPositionBottom)

'Axis Properties
With objAxis
.HasTitle = True
.Title.Caption = "Time"
.Font.Size = 2
End With
The problem is, it's reading 100s of lines in from a file and plotting the
graph, and trying to output the time for each entry!
Is there a way of reducing the x-axis labels so it would show hourly (for
example)
11:00 12:00
13:00
rather than trying to fit everything in between in also! (believe it or
not the entries are at 10 second intervals!)

I don't want to lose the values in between though.

 

[the G]

Brilliant - thanks a lot....

used :

'Axis Properties
With objAxis
..HasTitle = True
'.Scaling.Maximum=100
..Title.Caption = "Time"
..TickMarkSpacing=100
..TickLabelSpacing=100
..Font.Size = 8
End With


in case anyone else is interested....(!)