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

[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

 

[Dave Curtis]

DoHi,

Do you want to show these results graphically, or in the form of some sort
of output table?

Dave

url:http://www.ureader.com/msg/10355820.aspx

 

[Robert McCurdy]

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