From these formulae sheets I have line graphs for each of the 20 columns, with a seperate simple bar (0 or 1) as a second series on the same graph. The line shows the monthly movement, and the bar shows seperate instances.

All clear (as mud?)

As it is a date based spreadsheet and is updated monthly, new rows are added to the data sheet each month, and the formula sheets are updated manually as required. No problem.

But updating the graphs to include the extra row of data in the 2 series involves 20x a lot of mouse work.

Is there any way (macro?) to make the graphs automatially update and show the data for each new line that is added to the formula sheets? as the data is in columns, is it possible to make a graph of a column, that adds data points as data is entered in the column?

Sorry this is so long and convoluted, but I didn't want to leave anything important out.

Many thanks

Hugh