radar plot with category label changed

[ltok]

Hi

I tried this example vi, Line Graph (Excel).vi, with some modification as shown in the attached picture. I changed the plot to a xlRadar. After I run the vi, I got the result as shown in another attached picture. I would like to know how to change the font size of the Category Label programmatically in my vi.

Thank you & Regards

Lee

[Craig_D]

Lee,

Please see this post for more information on how to accomplish this.

Craig D

Applications Engineer

National Instruments

[ltok]

Hi Craig,

I appreciate that you replied. However, I am disappointed to what you referred me to.

I do not know if you have tried it according to my requirement before recommanding me to look at that post. I have tried and it did not work at all. It may work for normal line graph (I cannot be sure as I did not try) but it definitely did not for Radar type of graph. The Category Label did not change to a smaller font even when I tried inputting a numeric zero to Legend>>Font>>Size. As I only need to change the Category Label, I only did not use the property node to change the title font size.

If it works on your side, could you tell me what vi you use (whether from example finder or otherwise)?? I believe you also modify your Excel_Insert_Chart.vi as shown in the post you refer me to. If not, could you please show me how you do that?

Hope to hear good new from you soon.

Thank you & Regards

Lee

[Craig_D]

Lee,

I thought that the example would work the same with the line graph and the radar graph, but it looks like I was mistaken.  I attempted to drill down to the property nodes and change the font size there, but this was unsuccessful.  Digging into the lower level VIs which the Set Graph Font VI calls, I could not find a way to do this either.

The problem stems from the Axis Type input on the Set Graph Font VI.  The options are xlvalue, xlcategory, and xlseriesaxis.  Certain scale types cannot be used with certain chart types. For instance, xlSerisAxis cannot be used with any chart type because it is only supported in 3D charts (which we do not support in RGT). Further, xlCategory is only valid with the xlXY charts and xlBubble charts--which the radar graph is not part of.

Therefore, you won't be able to change the category label font size with the built in functionality of the RGT.  Since the RGT uses ActiveX calls to Excel to manipulate the graphs, if you wanted to build in this functionality, you could do so with ActiveX.  Your best source for this would be the MSDN.

Please let me know if you have any more questions.

Regards,

Craig D

Applications Engineer

National Instruments