I want to include a vertical axis title in a chart. Kind of bodgy quality control charts. Table has many rows. Each row is a different chart. I can look at the charts in turn by dragging the series (=SERIES(,Sheet1!$F$19:$L$19,Sheet1!$F$20:$L$20,1)) down row by row and inspecting the chart. I would like either the vertical axis title (or a label anywhere) to reflect the row that the data are showing.
But =Sheet1!$A20 is not allowed, only =Sheet1!$A$20
Can I construct a formula in cell A10 that will reflect the value in A20 when the series is
=SERIES(,Sheet1!$F$19:$L$19,Sheet1!$F$20:$L$20,1) and reflect the value in A21 when I drag the range down so that the series is
=SERIES(,Sheet1!$F$19:$L$19,Sheet1!$F$21:$L$21,1), etc
Thanks
