#1
|
|||
|
|||
Pie Charts
I need to keep track on a daily basis how many hours are being used by multiple people from the total number of hours allocated to a job.
I would also like, if possible, to show this data in a pie chart for easy reference. For example, I have 15 people, and, say 30 jobs, each job having an allocated number of hours. Some of the people may work on more than one job during a day. I have previously done a spreadsheet showing the Person/Area/Hours spent but I am lost how to convert this to a pie chart. Any advice on the spreadsheet and pie chart would be greatly appreciated. |
#2
|
|||
|
|||
Hello & Welcome to the Forum,
Let's start with seeing your data. Can you please post a worksheet with a sample of what you have? |
#3
|
|||
|
|||
Pie Charts
Jeffrey thank you for looking at this. Spreadsheets attached.
|
#4
|
|||
|
|||
Sorry, but your examples don't help all that much.
If you can give more detail on how to chart the data it would help to get you where you want to be. Plus, you have two examples and both with different layouts. |
#5
|
|||
|
|||
Pie Charts
Not sure what detail you need. Is it possible to make pie charts on each individual spreadsheet?
|
#6
|
|||
|
|||
Quote:
You have to help us more by showing the input data. Not the data as you have it, but what exactly in the data should be in the chart. Surely it's not all the data. Look at these sites for some inspiration... http://www.andypope.info/charts.htm http://peltiertech.com/jons-excel-and-chart-pages/ |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Charts | mina-mi | PowerPoint | 0 | 05-08-2012 03:37 AM |
Organization Charts | CactusJohn | PowerPoint | 0 | 12-04-2011 05:04 AM |
Line charts | TomTouch | Excel | 0 | 09-14-2011 06:44 AM |
HELP PLEASE!!!! Custom pie charts | skinnyginger | PowerPoint | 1 | 06-15-2011 07:52 AM |
Using Charts | miller0822 | Excel | 0 | 02-10-2006 08:02 PM |