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

Anyone using roofstock? Model seems really interesting. Would love to talk to someone using it.

like

Ya’ll take ya vitamins today?

likehelpful

Best way to learn / manage flows. As a functional person???...haven’t wrapped my head around complex flows built by others. And not trailhead

like

How long it takes to get the technical interview result?

like

Sent Becker a question about a practice problem… And they told me not to read too deeply in the words of the question…

Post Photo
funnylike

Hi all, I am trying to DCA bi-weekly into Vanguard ETFs, (VO, VTI etc). It seems like Fidelity does not support auto buying of non-Fidelity ETFs. So I was wondering which of these options you think is best?

1. Open a Vanguard Invest account
2. Look for Fidelity ETFs that are similar to Vanguard ETFs
3. Use smaller brokerages like SoFi l, Robinhood etc.

I really do not want to manage nor be active. My goal is to log-in like once every 6 months.

Thank you all.

like

Just paid off student debt, have around 7K in savings - any tips on what to do ? Should I save up more till i hit 25-30K (do have a wedding potentially coming up in 2 years) or start dumping all money into stocks and btc? Currently putting 10% to Roth and make 100K pre tax income if that’s any help

like

Who / what do you list as your contingent beneficiary when your spouse is your primary, you don’t have children, and you don’t have anyone in your family you trust with your finances if something were to happen?

like

Is there a calculator that I can put in all my investments and see how it works out in 50 years? I know each brokerage has their own projection thing, but just wondering if there are any other tools where i could combine everything?

Seeing how the environmental problem is growing in the world and nobody is doing anything to stop the pollution of the big nations (China, USA, Russia), it makes me think as a mathematician that our days are numbered.

like

Best consulting firms to work for that will allow 100% remote work indefinitely regardless of what clients do?

like

I feel that way too bud

Post Photo
like

Got a client who’s asked for a POV on how covid-19 will affect buys across ALL verticals & channels. Of course it’s urgent. Can we please share what our companies are saying? Teamwork time, folks.

like

Hey guys, question regarding new years resolutions. Anyone know some good books about how to lead better and step up to become a great CD?

I'm up for election next year. Kind of feel like I'm in Squid Game right now.

I've signed on to this, I'm really close to the end, but at a certain point I feel like I just want to check out of the game (and go in-house or something).

like

Hello fine people,
I have a question. I am a GDS employee wishing to relocate to another country as EY country “x” employee. The plan to relocate to country x was already in motion, if not EY then another org. The EY partner from country x is very interested in having me join their team but not sure about my GDS partner because they will be losing billing and may not like it. Is there a way I can approach this with my leaders? Any advice is greatly appreciated.

like
like

high school me 🤝 attorney me

Post Photo
likefunny

Looking for a stylus for older iPad models (non pencil compatible) fit notes taking ... any recommendations ?

like

I’ve been wanting to get on the course since quitting college golf but only the intimidating managers here play golf :(

like

Additional Posts in Excel Genius

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

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

like

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

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

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

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Would anyone be willing to teach me vlookup?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

like

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

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

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 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

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

Any weekend or online excel course recommendations?

like

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

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