12 month rolling stats

Question

I need to create spreadsheets that contains statistical information in a 12 month rolling stat.  This is to track health and safety stats.  I will have 4 or 5 site spreadsheets that link into a company wide YTD spreadsheet.  This in turn will need to link into charts.  Does anyone know of a tutorial that will show me how to do this.  I have given a sample of the information I need to track below, but there is much more.

Company Exposure Hours	2813	2670	3620	2928	3121	2616	2774	2174	2497	4038	3485	1929	34665
Sub Contractor Exposure Hours	13	15	82	47	177	83	149	313	0	32	57	57	1022
Total Exposure Hours	2826	2685	3702	2975	3121	2616	2774	2487	2497	4070	3541	1986	35279
# of Employees	21	21	15	10	9	13	15	8	8	15	11	5	0
Total Injury Frequency	0	0	0	0	0	76	0	0	0	0	56	0	11
Total Recordable Injury Frequency	0	0	0	0	0	76	0	0	0	0	0	0	6
Lost Time Injury Frequency	0	0	0	0	0	0	0	0	0	0	0	0	0
Severity Rate	0	0	0	0	0	0	0	0	0	0	0	0	0

Answer 1

Hello,

Thank you for posting the question in Microsoft Community.

As per the description provided, you would like to know how to create a chart for a spreadsheet then combine/link the chart with other 5 sites spreadsheets.

As for as creating chart is concerned, the chart can be applied only to one data source, but it can have a secondary access like it can show the showing results for each columns of spreadsheet.

In order to display the results of all the 5 sites spreadsheets in one chart then you may have to combine all the spreadsheets into one raw data and then link into a chart.

You may use the ‘Line Chart’ to display the YTD of spreadsheet in Excel.

You may go through the link below which provides information on available chart types in Excel 2010 and its features:

http://office.microsoft.com/en-us/excel-help/available-chart-types-HA010342187.aspx

If you need any more clarifications, do reply and we are here to assist further.

Thank You.