Pivot Chart Secondary Axis Issue with Slicer

[bbr]

Hi

I have the following example of a pivot table, pivot chart and slicer:

Untitled.jpg

The pass rate (%) is on a seconary axis as a line graph and looks fine when you have 2 or more names selected on the slicer. However, if you just select one name on the slicer the secondary axis is not visible:

Untitled1.jpg

I have added labels to the secondary axis and you can see the "90%" showing but no line.

How can I get the line to go across the whole series?

Many Thanks

[judgeh59]

there is no line because it's one data point....I believe....

[bbr]

there is no line because it's one data point....I believe....

I know I can add a marker which will put a square at the data point but is there no way to have a line go across the graph for a single selection?

[judgeh59]

oh, I get it now, sorry about that...not that I know of...I'll keep looking...maybe somebody can jump in....