Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a chart where i would like to give an option to switch betwenn X and Y axis. I am not clear how to proceed......
Regards
Sagar
You could probably do this with a macro but the easiest way would be to create a duplicate chart with the switched axes, lay them on top of each other (or in a container) and set a conditional show based on a variable value. Then use a button to toggle the value of the variable.
Hope this helps,
Jason.
What do you mean by "switch between"?
Hi,
By switch between i meant, if i click a button on the report my X axis of the graph should change to Y axis and vice-versa.
Regards
Sagar
You could probably do this with a macro but the easiest way would be to create a duplicate chart with the switched axes, lay them on top of each other (or in a container) and set a conditional show based on a variable value. Then use a button to toggle the value of the variable.
Hope this helps,
Jason.
Hi
Thanks for reply
Actually i was looking for some other option.
Regards
Sagar
OK - here's another way. See attached. I have created 2 variables that determine what the X and Y axes should be. These variables are used in the calculated dimension and expression and a button toggles the values.
Hope this helps,
Jason