Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I wanted to hind the chart if continent is not selected in the filter.
please find attached file for reference.
Thanks
Hi,
Try this..
Goto Document Properties -> Security -> Uncheck 'Show All Sheets and Objects'
And In the Chart Layout give this. =GetSelectedCount(Continent)
Attached your sample
You need to go to the layout tab of the chart, then under show you need to put conditional expression -
like getselectedcount(Field) <>'0'
Hi Shivesh,
it's not working...
Hi
PFA application, when you'll select any value in F listbox, then only the chart will be displayed.
Hi Shivesh,
Thanks for your reply.
could you please try the same logic in the file I have attached as I am not getting the expected result in that file
thanks
Sorry man, i don't have license as of now, and would not be able to open your attached file 😞
Hi,
Try this..
Goto Document Properties -> Security -> Uncheck 'Show All Sheets and Objects'
And In the Chart Layout give this. =GetSelectedCount(Continent)
Attached your sample
Hi Settu,
thanks, I have to the answer.
I have one more question which is posted in this group yesterday with the subject line
"Show data from the January Month till the month selected for the respective year"
could you please help in this as well. you can consider the attached file for your reference for the same.
thank you once again
sure. will have a look
Hi Settu,
Required help from you.
I have posted a query with subject "Show percentage of count in Pie Chart".
Could you please look into it & help me out.
thanks in advance.