Clicking On Single Line in Line Graph & New Chart (Graph or Pivot Table)

[#1]

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

[MayilVahanan]

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

[#3]

Thanks so much, I really appreciate it.

[#4]

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