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

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 do I set up spread sheet for demographical data to get graph.
 

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

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

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
"GC" wrote in message ...
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