Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like
Posting as :
works at
You are currently posting as works at

Related Posts

What is the work that an Associate Consultant does in the Deal Advisory team? I have an interview for the same role.

like

Lol shots fired

Post Photo
likefunny

Does FIL provide Corporate NPS for tax savings purpose?

How do you go about getting your first project manager job

like

Has your company made vaccine mandatory?

like

16 yoe experience in full stack development with Java. Ctc 32 LPA, how much should I be asking when I’m currently interviewed for engineering manager/senior manager position?

like

Hi Fishes, any openings for B.E freshers (2022 batch)? Please help.
If any suggestions on how to apply too, please let me know.

After rejecting big companies like Infosys,Wipro, etc. I've joined EPAM Anywhere due to wfh permanently and it's perks. But after spending 1 and half month HR called me to search the opportunity outside of EPAM, means they're laying off people. It's unfair behaviour of the organisation. I've given some interviews they're playing interview interview with me, for the hiring process technical interview then for project - technical interview, client process - starts from 1st Round.EPAM Systems

likehelpful

I have 7 plus experience in c++. I am trying new job within Chennai location but I am getting 1 or 2 interview calls for a month. I know c++ is old language and openings are very less and competitor people also less.
Shall learn new courses like AWS... its totally different from my experience I am not sure it will help to my career.

Could you please suggest shall I continue with c++ or shall I go with other platforms. Since I am getting very low package.

like

Anyone here moved from EY to Accenture? Curious to know how was the shift, pros and cons for each company, any regrets? Waiting for an offer from Accenture but very conflicted on whether I should leave EY. Been there all my career and going to be a big jump.

like

Is there any issue, if the designation at the time of offer is different than that of relieving? Asking because, I am leaving IBM GBS, have told my designation as Senior software engineer ( offer letter had it) to the other company, but got to know that designation IBM will be writing on relieving letter will be application developer. IBM

like

Advice on taking the SHRM-SCP exam? I’m taking the exam tomorrow and not feeling as prepared as I should. Who has taken the SCP exam? How difficult did you find it?

like

I have experience in node.js and react with 3 yr fulltime and 1 yr internship. Current ctc is 6.5 lpa. How much be my expected salary?

like

Are you guys as busy as you were pre-COVID? I'm at a no name and have had two transportation clients not want to sell anymore after the massive hit in March and April

like

What are your thoughts on those who refuse to wear cloth masks as a healthcare professional?

like

What aspects would you look at when interviewing a person for a Manager position?

like

What agencies do you think are the most supportive of women and families? i.e parental leave, work hours, etc

like

Can please share to get job offer letter from any canada company for project development profile. Please suggest.

Current- no visa
In india
More than 5 years experience.

like

At the moment it’s actually both

Post Photo
likefunny
like

Additional Posts in Excel Genius

Any book recommendations on excel modeling for real world business applications?

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

What are your top Excel ninja tricks? Ones that few people know...

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Would anyone be willing to teach me vlookup?

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Each country has multiple txns. Some complete, some not. What formula should I use to say if Indonesia has ANY “not complete” then show me the term “not done”. Tried IF(Index Match) but only (cont.)

Post Photo
like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Hi! I’m trying to create a macro that pulls a copy of a sheet from a file with a certain date in the file name into a new workbook. Is there a way to do this?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

What would you consider "Advanced" or "Expert" level Excel usage?

like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Hi all! Is there a way to easily copy over all the rows from multiple sheets into one consolidating sheet? We have 32 teams filling out transactions in their own tabs and need to consolidate all tabs transactions into one long list of transactions. Thank you!

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal