Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All
I have a graph ( see example) where I have the OT% by Payperiod by VP. I am trying to see if I can click on one single VP line within the graph and it will automatically launch a new line chart or pivot table that I have created within the sheet/tab. I am aware of the use of " auto minimize" , but boss wants it as easy as he can for the VP sort drilling down - ie click down one leven - ie click again and down even deeper.
An assistance would be greatly appreciated.
Ps Does anyone know how to change the color of the title line of a object ie chart or list box?
Thanks again
Tim
Hi
As per my understanding, you can do like this
1. For select the line in chart for a Vp, you want to display the another chart? if so,
create a line chart/pivot table and its properties->layout->Conditional
= if(GetSelectedCount(VP)>0,1,0)
2. Color for title
Properties->caption-> text color in either active/inactive caption
Additional info, for font style/size - caption->font
hope it helps
Thanks so much, I really appreciate it.
Mayil
When you use this condition, the initial line graph is blank as the count is 0 and so you are really unable to select a graph.
Thanks
Tim