#1
|
|||
|
|||
Column chart, comparing shift production by day, week, month
I am trying to create a set of charts where I can track the production, per machine, across 3 shifts, per day, per week and per month (and eventually, per year).
Our weeks start with 3rd shift on Monday, With the data provided, (spreadsheet titled "shift comparison"), starting with the first Monday, using a standard column chart, I need a chart that shows what each shift produces, that's the number in the actual column, compared to the other shifts. I'd like the date under the three bars (shifts) that represent a single day. Blank spots in the "actual" column are actually zero's, indicating that we didn't work that day or that machine was down that shift. I do not want to hide that, it should be part of the overall equation. Then somehow, show the cumulative output of each shift as it grows every day of the week, finishing up on Sunday, or the last day of the month, etc. I'm not wedded to any single way of doing this, just so I can do it. Thanks in advance. |
#2
|
|||
|
|||
The first chart is easily done with a pivot table. First of all, I organized your data so each shift has its own column. Now go to the Pivot tab. The chart shows the total for each shift for a specific period that you choose from the timeline below the chart.
Currently, it is set to select for days. You can select any period of consecutive days. Select your start date then, while holding the shift key, select your end date. You can also select by months, quarters, and years. Is this all you need? (P.S. I just noticed all your dates in your data table are for 2016.) |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bar Chart issue when Month Name Changes on Axis | randolphoralph | Excel | 4 | 05-13-2016 05:08 AM |
MS Project 2013 Reports: ACWP in Timephased Line Chart does not match ACWP in Column Chart or Table | billcary | Project | 3 | 09-22-2014 07:10 AM |
Noob here - I need a shift calendar by days with count of shift. | freeman | Excel | 8 | 09-12-2012 08:45 AM |
Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
Displaying work week in month view | tupham | Outlook | 0 | 10-28-2008 02:55 PM |