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

My current package is 6 lakh and at time of screening I said expected 10 lakh , should I tell I expect 11 lakh in managerial round or different nos will lead to rejection.Also salary negotiable is done by manager only? Experience - 3 years 3 month

Hello, I've been working as a Healthcare Consultant for over 4 years now & I am currently a Consulting Manager near the Philadelphia area seeking an opportunity in NYC. Anyone know anything avail?

like

I finally got through to the Hiring committee round at Google. Should I be excited or nervous or not read into at all?

likeuplifting

Anyone work for Nevro Medical Device Company before? Can you tell me what the culture is like and if they have career growth opportunities for Senior Analysts?

like

MBB AP about to exit to non-FAANG tech. Would you expect a signing bonus and/or pre-determined severance pay if things don't work out with the new company? Anything else that people have negotiated during their exit? I'd be leaving a large amount of bonus on the table to leave before the end of the year.

like

Currently SA at Accenture doing Cloud Advisory, ~1.5 years of work experience. I am currently trying out an MC engagement and am enjoying it immensely, and now I’m daydreaming about doing MBB consulting.

Is this career move from SA at ACN Tech to BA at McKinsey possible? What’s a good way to achieve this? I’ve only heard of people moving there from ACN Strategy.

like

Hi All,
Just to be in a proper position to negotiate/expect, how much can I make with 1.8 YOE in the current market for a full stack developer. Excluding the likes of MAANG or alike paying companies. What is the ideal salary and the max I can make at this YOE. Please someone reply to this , it will be helpful for me.

like

What would the in hand salary be for this compensation. Thanks in advance.

Post Photo
like

Just wondering if I got lowballed, should a software tester get paid 65k, entry level/straight out of college with a CS degree in the DC area

like

Chicagoland Fish: I’m researching salaries for a CFO role that I’m interviewing for. The role is with with a middle-market insurance agency with about 150 employees.

I know there are a lot of factors but what range are other CFOs in the area earning in total comp?

likesmart

Amazon should act as Santa during the holidays and deliver one gift fully wrapped from your wish list for free every year to everyone with Prime just to say thank you for choosing us. Bad idea or good

like

We Indians are so poor we can't think anything else except money. Whole Fishbowl is all about YOe and Salary. No one interested about if any company doing any innovation or not. B-Tech colleges put ads with Package and Campusing only. Almost 99% Indian YouTube thumbnail is like "5 lakh to 40 lakh", "Interview Experience in bracket 50Lpa" etc.. Hardly we can see Foreign Editorial things marked with Packages.

#sharing thought.

likeuplifting

If you exit after your first promo (~2 YOE), what level roles can you expect to be competitive for in industry? Analyst/sr analyst?

like

Tips to build my brand and network as a junior practitioner navigates their career to the next level at the firm?

like

Any consulting -> Tech sales people out there? Curious how consulting experience is perceived both from a compensation and placement standpoint in the tech world…? What should my expectation be? For context — I SDR’d as a senior in college and was promoted to AE right as I took a BA offer from McKinsey. Wanted to get broad exposure & become a more analytical problem solver… dont regret my decision at all but really loved sales and would like to get back around my 2-3 yr mark.

like

How much variable pay is expected to be paid (and when) if I join SAP in June

like

DM me if your skills match .
Minimum 3+ Years of working experience with Mulesoft
Should have Mulesoft Developer Certification.
Hands-on experience on Building interfaces on any ESB platform.
Experience in Web API: SOAP, REST and authentication methods such as OAuth and SAML.
Mulesoft integration developers are also responsible for managing the any point Cloud Hub environment and supporting existing customer implementations.
Work on enhancements and bug fixes to existing Mulesoft applications.

like

KPMG India is looking for Java developer with cloud experience.
Let me know if any one interested to work with kpmg..

like

Every week, I scroll through Facebook and click the “X” button to hide all the ads just to screw up their ML model. Sometimes I win. Sometimes they win. 😅

likefunnyuplifting

Does Oracle have holiday shutdown?

likehelpful

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

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

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

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

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

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?

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

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

Why don't recent grads know how to use excel?

likehelpfulfunny

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

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

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

like

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

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