ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Z Chart i.e. top rolling annual bottom rolling monthly middle cum. (https://www.excelbanter.com/excel-worksheet-functions/10455-z-chart-i-e-top-rolling-annual-bottom-rolling-monthly-middle-cum.html)

wat prin

Z Chart i.e. top rolling annual bottom rolling monthly middle cum.
 
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


All times are GMT +1. The time now is 03:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com