Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
Is there any way to hide or display a straight table chart based on the selection of a another chart present in the container (the container has 6 chart objects). The chart outside the container should be displayed only when Chart 3 is selected in the container. Please help
Regards,
J. Ravichandra Kumar
No such inbuilt feature so far to get active chart in container, however, you could try with macro - something like:
Set ContainerObj= ActiveDocument.GetSheetObject("CT01")
Set ContProp=ContainerObj.GetProperties
vActiveIndex="CT01-" & ContProp.SingleObjectActiveIndex
ActiveDocument.Variables("vActiveIndex").SetContent vActiveIndex, true
been discussed here:
Hi Ravi Chandra,
Can you share one sample file and expected output.
Can explain it little more ?
!Hi Nagarjuna,
Please find the attached test.qvw file, the container has two charts (Test1 and Test2) and a separate chart (Legend). On selection of chart 'Test1', the Legend chart should show up otherwise the Legend chart should be hidden.
Please let me know if it makes sense.
Regards,
J. Ravichandra Kumar
Means If u click on Test 1 it shd show up Test 1 Legend , if u select Test 2 do dont wont to see Test 2 Legend .Is that correct ?
Yes, you are correct. when I select test 2 chart the Legend chart should be hidden.
Regards,
J. Ravichandra Kumar
Like this U want?
Check and Let me know.
Hi Nagarjuna,
The Legend Chart is always showing up. its not getting hidden.
Regards,
J. Ravichandra Kumar
PFA
Hi Nagarjuna,
Sorry to say this, the above attachment is still not working.
Regards,
J. Ravichandra Kumar