View Single Post
  #1   Report Post  
 
Posts: n/a
Default Chart and Data Problem

Hello

I have a problem.

For my work, I compile staff absence spreadsheets with the following
columns.

Name
Department
Month
Reason.

What I want to do is create a chart for each month based on the department
data (eg. a pie chart for January may show two thirds of the area being 'IT
Department' and one third may say 'Personnel Department'.

How would I do that ?

Regards

Jonathan