format a buried data series
 

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?

format a buried data series
 

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.




On Nov 3, 9:59*pm, Robert H wrote:
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?