format a buried data series

[Robert H]

I have one data series that is buried in the floor of a chart. I want
to select the data series and assign it to the secondary axis. I used
to be able to select the individual data series in a menu ( I think)
even if it was not selectable on the chart because it was buried in
the floor. I looked around on the ribbon but cannot find it.
any ideas?

 

[Robert H]

I found it. Select a chart then the layout tab of the Chart Tools
ribbon, in the upper left hand corner of the ribbon there is a drop
down to select the different areas of the chart and the individual
data serieses.