asked on 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
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
VBA
Last Comment
Frank .S
ASKER
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
- 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
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.
ASKER
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?
- 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?
Where does the data come from?
ASKER
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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
hi martin, I have attached a wksht with both;
- bar chart
- bar chart data table
E--fhd_2016-bar-chart-only-1.2.xlsx
- bar chart
- bar chart data table
E--fhd_2016-bar-chart-only-1.2.xlsx
Can you manually create a chart so that I can better determine what you want?