Excel Chart Obect position - Using VBA

[nagovind]

Dear All


I have a x-y scatter chart to plot the values

i will switch it ON and OFF the values using VBA; during the same time i need to show an


ARROW head simultaneouly get switched ON/ OFF OVER THE CHART Area..the same arrow head nothing but as object can be deleted ...but while switching ON the x-y scatter new arrow head should be shown in the same place (co-ordinate)


Is it possible using excel VBA


Please help

 

[Hui]

Nagovind


You have 2 basic options


With VBA


Add an arrow to your chart and thenwith VBA


With ActiveSheet.Shapes.Range(Array("Rectangle 1")) 'Change name of object to suit

.Visible = msoTrue 'Shows object

.Visible = msoFalse 'Hides object

End With


Without VBA


Add another series to the chart which will only have one set of coordinates

Change coordinates to suit desired location

Add an arrow to your workbook

Select an Arrow, Copy

Now select your new single point Series and paste

Your points coordinates can have a formula to make them appear where ever you like on the page