If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
It sounds like you'll have to create a pivot table with a pivot chart to do
this. See http://www.allaboutoffice.co.uk/expivot.htm for details. The pivot table can count the number of instances of each department and then if you select only the month you require you can use a pie chart pivot chart to display that data. Andrea Jones www.allaboutoffice.co.uk www.stratatraining.co.uk www.allaboutclait.com " wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with data not getting plotted | Scott Ehrlich | General Discussion | 2 | January 25th, 2005 05:17 AM |
Help with data not getting plotted | Scott Ehrlich | Charts and Charting | 1 | January 23rd, 2005 05:15 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |
Chart Problem ( X-Axis Shrinks as new data added) | Mian Mazher | Charts and Charting | 1 | May 19th, 2004 05:08 AM |
Help with Data (Table) below my chart | Jon Peltier | Charts and Charting | 0 | November 20th, 2003 03:36 PM |