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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies