Excel Chart

[Lindsay150]

Each week, we make a timesheet for all of our employees. I've beeing making charts to see what jobs people were doing and where they were working. To make the chart I was selecting the data then clicking on chart and it would give me a bar graph. Some of the sheets will not produce the graph. It says there are no recommended charts. 

Is there anything I can change to try to get these graphs for each week? I've highlighted the entire chart and put it on a new sheet and that worked for one but not the remainder.

Thanks!

[#2]

+Hello @Lindsay150 , with charts, the devil is often in the detail. If Excel cannot determine what the data for the chart should be, then it cannot make the chart.

Can you post such a problematic worksheet with names anonymized? Please use the paper clip icon to attache the file, then please explain which cells you select to create a chart.