LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

legend placement in Excel

Solved!
Go to solution

Hi,

 

I'm trying to control the placement of a chart legend in Excel from Labview using active X. The VBA lines I need to perform in Labview are as follows:

 

ActiveChart.Legend.Select

Selection.Position = xlBottom

 

The problem I'm having is that I can't find an automation refnum for Selection. I have tried searching the Microsoft Excel Objects library but it does not seem to be there. I have attached a screen shot of the code. I am relatively new to active X so any help appreciated.

 

Thanks

LMS17

 

 

0 Kudos
Message 1 of 3
(2,748 Views)
Solution
Accepted by topic author lms17
Here is what you need yo do. Look at the gif
Tim
GHSP
Message 2 of 3
(2,724 Views)
perfect...thank you.
0 Kudos
Message 3 of 3
(2,721 Views)