excel form that produces a graph or bar chart

hi experts ive attached an excel file with info that id like to create a basic user form that produces a bar chart or graph.
basically i enter through the form;
- user name
- job number or id
- job client
- job rating id

then its to total number of jobs per user and total number of all users, no of job ratings, no of clients
- the purpose of this is to track very easily a workflow chart that is automated by the info entered into the form
form-to-produce-graph-or-barchart.xlsx
Frank .SBuilding EstimatorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Is "user name" the same as your "Initials" columns headings? If not, where do the names come from?

Can you manually create a chart so that I can better determine what you want?
0
Frank .SBuilding EstimatorAuthor Commented:
hi martin, i have created and attached a manual bar chart for your reference
- what i havent attached below the bar chart and i need is an information table that i enter the same info you see in the bar chart into a table of information which then automatically updates the bar chart
- some jobs will overlap each other so if you could recommend what can be done, ie a job may still not be complete on say 12/12 but the following job needs to start on say 11/12 so the bar chart will need to show the overlap of dates
- the scheduled start & completion dates on top of the bar chart need to be in 1 color and the actual for start and completion in another, if possible to have the ability to turn off different levels of detail?
bar-chart-only-1.1.xlsx
0
Martin LissOlder than dirtCommented:
OK, that's not really a chart, but rather just a sheet with highlighted cell data. I also don't see any relationship between the workbook you originally posted and your bar-chart one. In any case I'm sorry to say that I don't think I'll be able to help you.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Frank .SBuilding EstimatorAuthor Commented:
thats ok, i dont think you have understood the data..
- row 8 are dates that jobs start & finish
- col b are the persons who have been assigned the jobs
- rows 5&6 is the legend/ colors that represent where the jobs are at
- job id and client name
- cells c9-p17 is the data table
- col q counts the number of jobs per person that have been assigned jobs

this has been created all manually, all i wanted was to enter all this info into cells below, say a table and for a bar chart to be created. could you recommend a bar chart template i could use then?
0
Martin LissOlder than dirtCommented:
Where does the data come from?
0
Frank .SBuilding EstimatorAuthor Commented:
hi martin, the data comes from a very basic table that i would create directly under the bar chart. the data has the same info as you see in the bar chart
0
Martin LissOlder than dirtCommented:
Are you able to  upload a workbook or file that contains the data for the "very basic table"? Without it I can't do anything more.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Frank .SBuilding EstimatorAuthor Commented:
hi martin, I have attached a wksht with both;
- bar chart
- bar chart data table
E--fhd_2016-bar-chart-only-1.2.xlsx
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.