how do I set up spread sheet for demographical data to get graph.

  • Thread starter Thread starter GC
  • Start date Start date
G

GC

I need to set up a spread sheet to be able to get age, sex,service usage
numbers, site utilisation, presenting issue e.g., drug and alcohol, region,
percentage of use base on population e.g, 80 staff
 
How are you intending to get the data or enter the data into this sheet?
How many worksheets or tables will you need?
What is the final display options: Examples, Reports, Charts, Pivot table?
And lastly who are the end users, and how do they - or u - wish to use the workbook?

Answer these questions and the sheet(s) design is fairly easy.

As the data seems to be of a statistical nature, I'd suggest googling for examples of this data in a XL format. Although I've yet to see those that work in Education or for the gov't create anything using any of Excels built-in analytical functions. They are the most boring and poorly crafted examples of this data one is ever likely to see :) - still it may give you some ideas...

Post back if you need more help.


Regards
Robert McCurdy
 
Back
Top