Hello,
I would like to have a graphic chart created which provides me a target value and a actual value. If the target value will not be reached within a specific time frame. The bar should turn into another color "Green" "Orange" "Red".
I need to set-up two things:
1: have a bar chart created which displays a different color when the work is not done within a specific time frame
2. provide a paramether which displays the time used for a specific tasks to calculated the current prodcutivity
so actual time vs used time and a target time
I have a file with an example set-up but this file needs to be amended to above mentioned requirements
so we need to work with on bar chart per shipref (column A) which displays the amount of boxes processed vs the total boxes.
and the side bar should display the time for example 06:00 AM up to 23:00 PM.
the bar should display a % (productivity) and a color (red,orange or green)
targets to be defined
I will send you another example where you can see what I mean with the time an progress(data 2xlsx)
the main goal is to display the productivity in real time
another example. Example date 1 we need to use to build
Thanks
(lowest bidder win)
I understand what you want and I can deliver it in less than 6 hours. The key is to use conditional formatting for the value, respective of the target. Looking forward to working together!
As a mechanical engineering major at Lehigh University, I am constantly exposed to having to collect and record large amounts of data. Whether it is from experiments or theoretical data collection, I need to be able to record that data quickly and accurately in order to later present it. I have become extremely proficient in this as the years went on (I am currently a junior).
This summer I am working as a mechanical engineering intern as a specialist in large data collection and representation on Excel. Most of my day is spent sifting through large spreadsheets and picking out the useful information. I later have to reorganize this information in a way that is easier for clients to understand.
I would love to help you with your project. Feel free to contact me with more specifics so we can discuss the project and what you want me to do for you.