I have a database where I would like to plot graphs from data of different periods and different series.

My current method is to go to the data set formulas and changing data range. The tricky part is that I might skip data series because I am selecting the series required for each chart.

Can someone suggest how to do plot the different graphs efficiently and quickly.