Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
Is it possible to show multiple bar charts based on the selection of values in the list box?
For example, if I select the value "Cargosmart" in the list box as in the below image it has to show three bar charts in a sheet and if I select a value "GTNexus" in the list box, 5 bar charts will be shown in the screen.
So, please help me guys is it possible to do and if it is, help....
for Cargosmart
go to chart properties -> layout tab-> conditional show
write the condition
if([Carrier Name] = 'Cargosmart',1,0)
for GTNexus
if([Carrier Name] = 'GTNexus',1,0)
follow this in every chart
Adding on to Arul's reply:
If you want chart1 to be displayed for Cargosmart and GTNexus, then in chart1's conditional display put
if(([Carrier Name] = 'Cargosmart' or [Carrier Name] = 'GTNexus'),1,0)
Thanks guys..
PFA, just play with list box by selcting Month as Apr 2016 or Aug 2016.
are u looking for the same?