Home

Excel Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-829596%22%20slang%3D%22en-US%22%3EExcel%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-829596%22%20slang%3D%22en-US%22%3E%3CP%3EEach%20week%2C%20we%20make%20a%20timesheet%20for%20all%20of%20our%20employees.%20I've%20beeing%20making%20charts%20to%20see%20what%20jobs%20people%20were%20doing%20and%20where%20they%20were%20working.%20To%20make%20the%20chart%20I%20was%20selecting%20the%20data%20then%20clicking%20on%20chart%20and%20it%20would%20give%20me%20a%20bar%20graph.%20Some%20of%20the%20sheets%20will%20not%20produce%20the%20graph.%20It%20says%20there%20are%20no%20recommended%20charts.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anything%20I%20can%20change%20to%20try%20to%20get%20these%20graphs%20for%20each%20week%3F%20I've%20highlighted%20the%20entire%20chart%20and%20put%20it%20on%20a%20new%20sheet%20and%20that%20worked%20for%20one%20but%20not%20the%20remainder.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-829596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Echart%20bar%20graph%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-830601%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-830601%22%20slang%3D%22en-US%22%3E%3CP%3E%2BHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F358903%22%20target%3D%22_blank%22%3E%40Lindsay150%3C%2FA%3E%26nbsp%3B%2C%20with%20charts%2C%20the%20devil%20is%20often%20in%20the%20detail.%20If%20Excel%20cannot%20determine%20what%20the%20data%20for%20the%20chart%20should%20be%2C%20then%20it%20cannot%20make%20the%20chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECan%20you%20post%20such%20a%20problematic%20worksheet%20with%20names%20anonymized%3F%20Please%20use%20the%20paper%20clip%20icon%20to%20attache%20the%20file%2C%20then%20please%20explain%20which%20cells%20you%20select%20to%20create%20a%20chart.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Lindsay150
New Contributor

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!

1 Reply

+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.

 

 

 

Related Conversations
my chart can not smooth the points
inadotb in Excel on
2 Replies
Copy/paste no longer working in Excel
Jon Firooz in Excel on
76 Replies
changing Date format in a pivot table
ahmad ali in Excel on
12 Replies
runtime error 1004 : Method range of object - 'Global' failed
Lorenzo Kim in Excel on
16 Replies
INDEX & MATCH interrupted by Inconsistent Dates
shade206 in Excel on
18 Replies
Need to extract values from named cells (Get and Transform)
JEMagnussen in Excel on
23 Replies