I would like to produce a chart/graph (one worksheet on excel) which gives as
much performance details (financial) as possible. This worksheet would be
linked to p&l reports

Along the top would be the Annaul Rolling Average figures.
Along the bottom would be the Monthly Rolling Average Figures.
And from bottom left on the graph to the top right the Cumulative Year to
date.
All this data produced on 12 monthly periods.
Long, Long, ago this was called a Z chart and gave just about all the
information needed for performance, trends, annual comparasons, etc., at a
glance .Does such a thing exist any more?

Wat Prin