I have this urgent requirement in which i need to replace chart only when there is no data to display in chart with a text object "Select relevant data"
Can any one suggest me points to acheive this requirments?
you can hide the chart conditionally i.e. show only if condition=true and show the text object if condition=false .
You can also give a message in error messages button in your chart properties General tab. Like below:
This way you do not need any Text object to hide show.
Agreed either approach will work. i prefer the hiding as i control the formats better.
Definitely. However, i was just trying to use native chart properties that might help in this scenario rather than writing conditional statements in both the objects.
Retrieving data ...