Hi,

I am using writing some program (using LabVIEW) and in my program, I am
using ActiveX to call Excel and create a radar chart. I would like to know
how to change to font size of the category label of a radar graph.

Thank you & Regards
Lee

Does your program use VBA? If so, go into Excel and manually do what you
want with the macro recorder on, then adapt this recorded code into your
program.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Lee" wrote in message
...
Hi,

I am using writing some program (using LabVIEW) and in my program, I am
using ActiveX to call Excel and create a radar chart. I would like to know
how to change to font size of the category label of a radar graph.

Thank you & Regards
Lee

Hi Jon,

Could you give me a rough VB code on how to do that?? I am not using VB but
I believe it should be similar as VB is also using ActiveX. Correct me if I
am wrong.

I have searched MSDN but cant seems to link up what ActiveX are called to
change the font size of the category label of a radar graph.

Appreciate your help greatly.

Regards
Lee

"Jon Peltier" wrote:

Does your program use VBA? If so, go into Excel and manually do what you
want with the macro recorder on, then adapt this recorded code into your
program.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com

If you have Excel, you can use its macro recorder yourself. I just changed
the category axis label size in a radar chart, and this is what was
recorded:

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/13/2007 by Jon Peltier
'
ActiveChart.ChartGroups(1).RadarAxisLabels.Select
Selection.AutoScaleFont = True
With Selection.Font
.Name = "Arial"
.Size = 12
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
.Background = xlAutomatic
End With
End Sub

I would shorten it to this, since most of that code is reapplying defaults.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 7/13/2007 by Jon Peltier
'
With ActiveChart.ChartGroups(1).RadarAxisLabels.Font
.Name = "Arial"
.Size = 12
End With
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Lee" wrote in message
...
Hi Jon,

Could you give me a rough VB code on how to do that?? I am not using VB
but
I believe it should be similar as VB is also using ActiveX. Correct me if
I
am wrong.

I have searched MSDN but cant seems to link up what ActiveX are called to
change the font size of the category label of a radar graph.

Appreciate your help greatly.

Regards
Lee

"Jon Peltier" wrote:

Does your program use VBA? If so, go into Excel and manually do what you
want with the macro recorder on, then adapt this recorded code into your
program.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com