I have data table with dates from AQ8 to BU8 and products in AP9-31.

In any one particular month the factory may only make on product, however in
other months it may make all 23. I would like to plot a graph of this data
that updates automatically - dynamic ranges.

As a result I have a graph that can move between one and 23 rows of data to
plot (series), each with its associated series name shown in the legend.

I have tried looking at Jon Peltiers website, C Pearson and several
questions on this discussion forum - no solution seems evident. Plotting the
data is no problem but getting the legend to update seems to be the catchy
part as even if I make it dynamic when I delete a series the legend will show
REF#.