Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Learning about Charts
I am a relatively new user to excel and I have been asked to make a dynamic
Line Chart to show the total amount of work in 8 hour days, per 7 day week for a work group. When I say dynamic, I mean that the current week is the centre of the chart, to the right is the weeks of work dated in the future and to the left in the past. The way the information appears in the worksheet is the jobs are in rows and the info for each job is in the columns. Eg. Order, Work Center, Planner group, Work, Earl.start date. I need to group the Orders by weeks and the week being Saturday to Friday. Filter by Planner Group and by Work Centre as there could be more than one Work Centre per Planner Group. In my report I can have anywhere from 3,000 to 15,000 rows. I hope someone can point me in the right direction. All help appreciated. Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked Charts w/ Vertical Separation | Charts and Charting in Excel | |||
linkingof charts in worksheets to cells | Excel Discussion (Misc queries) | |||
Can't create dynamic charts | Charts and Charting in Excel | |||
i need help automating, or at least simplifying, my charts | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel |