Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2017, 08:52 AM
rossmoyne rossmoyne is offline Column chart, comparing shift production by day, week, month Windows 7 32bit Column chart, comparing shift production by day, week, month Office 2007
Novice
Column chart, comparing shift production by day, week, month
 
Join Date: Feb 2013
Posts: 9
rossmoyne is on a distinguished road
Default 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.
Attached Files
File Type: xlsx shift comparison.xlsx (27.5 KB, 21 views)
Reply With Quote
  #2  
Old 02-27-2017, 10:27 AM
gebobs gebobs is offline Column chart, comparing shift production by day, week, month Windows 7 64bit Column chart, comparing shift production by day, week, month Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.)
Attached Files
File Type: xlsx shift comparison.xlsx (32.0 KB, 29 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column chart, comparing shift production by day, week, month Bar Chart issue when Month Name Changes on Axis randolphoralph Excel 4 05-13-2016 05:08 AM
Column chart, comparing shift production by day, week, month 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
Column chart, comparing shift production by day, week, month 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft