how to change tick label spacing in Excel chart via activex

[martti]

My application collects data from data-logger, displays it in a LV-chart and saves the data in a hard-disk. Finally a test report will be automatically generated in an Excel sheet and chart using ActiveX. I cannot find a way to change tick label spacing in the Excel chart (not an embedded chart, but a separate chart sheet). Is it possible to do this with ActiveX?

[Ivaylo Iltchev]

With ActiveChart.Axes(xlCategory)
.MinimumScale = 1
.MaximumScale = 36
.MinorUnit = 2
.MajorUnit = 10
.Crosses = xlCustom
.CrossesAt = 0
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With

"martti" wrote in message
news:506500000008000000A3350000-1007855737000@exchange.ni.com...
> My application collects data from data-logger, displays it in a
> LV-chart and saves the data in a hard-disk. Finally a test report will
> be automatically generated in an Excel sheet and chart using ActiveX.
> I cannot find a way to change tick label spacing in the Excel chart
> (not an embedded chart, but a separate chart sheet). Is it possible to
> do this wi
th ActiveX?

[martti]

Thank you for your answer Ivaylo - but this is not what I'm looking for. You had just recorded an Excel-macro.
I intend to do it with ActiveX. I have succeeded in most of the operations to manipulate Excel sheet and chart with ActiveX, but not with TickLabelSpacing (for x-axis).
Operating system is NT2000, Office2000 and LabView6.02.
I'd appreciate any help - thanks in advance.

[Ivaylo Iltchev]

I hope this example may help you
My Office is XP - sp1, so relink property and invoke nodes to your office
version

regards



[Attachment ExcelCharts.llb, see below]


[Attachment ExcelChartsDoc.pdf, see below]

[martti]

Thank you Ivaylo - you solved my problem. Your example was great, it gives me the principle for using other properties that I'll need with my application.
Thanks again and Merry Christmas!

[Ivaylo Iltchev]

I hope atached llb and/or pdf document may help you
ExcelCharts.llb created with LV 6.0.2 for Excel 10 - Office XP SP1



[Attachment ExcelChartsDoc.pdf, see below]


[Attachment ExcelCharts.llb, see below]