SOLVED
Home

Can't create chart, option grayed out

%3CLINGO-SUB%20id%3D%22lingo-sub-190888%22%20slang%3D%22en-US%22%3ECan't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190888%22%20slang%3D%22en-US%22%3E%3CP%3EUsing%20Excel%20Home%20and%20Business%202013%20Version%2015.0.5023.1000.%20Just%20updated%20it%20now.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20this%20same%20problem%20with%20an%20old%20spreadsheet%2C%20where%20suddenly%20I%20could%20no%20longer%20add%20new%20data%20to%20the%20chart.%20So%20created%20today%20a%20new%20sheet%20with%20new%20data%2C%20just%2040%20lines%20and%205%20columns.%20I%20want%20to%20use%20data%20from%203%20columns%20for%20chart%20as%20I%20had%20in%20old%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20still%20couldn't%20insert%20chart%2C%20tried%20Help.%20The%20most%20relevant%20seeming%20thing%20had%20info%20only%20in%20video%2C%20only%20about%20Power%20View%20(%20which%20apparently%20my%20version%20doesn't%20support)%20and%20the%20dumb%20video%2C%20if%20you%20paused%20it%20or%20tried%20to%20go%20back%2010%20seconds%2C%20the%20%23%40%40%25%5E%20thing%20wouldn't%20restart%20unless%20I%20went%20back%20to%20beginning%20of%20video.%20%23FAIL%20on%20on%20so%20many%20levels.%3C%2FP%3E%3CP%3ESo%20I%20looked%20on%20this%20forum%2C%20and%20based%20on%20other%20threads%2C%20updated%20my%20version%20of%20Excel%2C%20checked%20that%20everything%20that's%20supposed%20to%20display%20is%20displayed%20(see%20attached)%2C%20and%20still%20problem%20exists.%3C%2FP%3E%3CP%3EI'm%20not%20a%20power%20user%20but%20I've%20always%20been%20able%20to%20use%20my%20data%20to%20create%20charts%20no%20problem.%20Any%20suggestions%20on%20what%20might%20be%20the%20problem%20now%3F%20TIA.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-190888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%20%26amp%3B%20Visualizing%20Data%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Egreyed%20out%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281583%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281583%22%20slang%3D%22en-US%22%3EIN%20Excel%202016%2C%20the%20share%20workbook%20button%20has%20been%20removed%20from%20the%20ribbon.%20You%20can%20add%20it%20to%20your%20Quick%20Access%20Toolbar%20temporarily%2C%20you%20may%20find%20the%20button%20if%20you%20select%20%22All%20commands%22%20from%20the%20dropdown.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281364%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281364%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F237347%22%20target%3D%22_blank%22%3E%40werkaroberto%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3EIs%20the%20sheet%20protected%20by%20any%20chance%3F%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3Eno%26nbsp%3B%20it%20is%20unprotected%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-281358%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-281358%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3EIs%20the%20sheet%20protected%20by%20any%20chance%3F%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3Eno%26nbsp%3B%20it%20is%20unprotected%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191836%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191836%22%20slang%3D%22en-US%22%3EYou're%20welcome.%20Glad%20this%20solved%20the%20issue.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191575%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191575%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20taking%20the%20time%20to%20make%20the%20screen%20shots.%20I%20THOUGHT%20I'd%20already%20tried%20unchecking%20that%20box%20but%20at%20any%20rate%20it%20worked%20this%20time.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191550%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191550%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20trick%20is%20to%20uncheck%20the%20box%2C%20see%20screen%20shots.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20470px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33754i7FAD64F3217C5D59%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Share%20WB%20button.png%22%20title%3D%22Share%20WB%20button.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EClick%20Share%20Workbook%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33755i852472858545C166%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Uncheck%20Sharing.png%22%20title%3D%22Uncheck%20Sharing.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EUncheck%20the%20box%20and%20OK%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191536%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191536%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20read%20my%20previous%20reply%20as%20to%20what%20happened%20when%20I%20tried%20to%20unshare%20it.%20I%20tried%20to%20unshare%20from%20the%20review%20tab%20(apologies%20that%20I%20didn't%20say%20specifically%20how%20I%20tried%20to%20unshare).%20What%20%22should%22%20happen%20isn't%20helpful%20if%20that's%20not%20what%20happens.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191530%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191530%22%20slang%3D%22en-US%22%3EYou%20should%20be%20able%20to%20unshare%20using%20the%20button%20on%20the%20review%20tab%20of%20the%20ribbon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191490%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191490%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20it%20is%20in%20%22shared%22%20mode.%20I'm%20the%20only%20user%20I'm%20sharing%20with.%20I%20tried%20to%20remove%20myself%20and%20Excel%20wouldn't%20let%20me.%20Instead%2C%20it%20suggested%20closing%20the%20file.%20I%20did%20that%2C%20re-opened%2C%20and%20it's%20the%20same.%20How%20would%20I%20make%20it%20unshare%3F%3C%2FP%3E%3CP%3EWhen%20I%20looked%20in%20help%2C%20all%20I%20found%20was%20vague%20video%20info%20that%20co-authoring%20is%20better%2C%20though%20it%20didn't%20bother%20to%20say%20how%20specifically%20it's%20better%20or%20even%20in%20what%20versions%20of%20Excel%20co-authoring%20is%20in.%20I'm%20using%20Excel%20as%20part%20of%20Office%202013%2C%20desktop%20version%2C%20not%20365%20version.%26nbsp%3B%20I%20also%20didn't%20find%20what%20I%20was%20looking%20for%2C%20how%20to%20turn%20off%20sharing%2C%20since%20I'm%20the%20only%20one%20using%20this%20spreadsheet.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191486%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191486%22%20slang%3D%22en-US%22%3E%3CP%3EI%20tried%20that.%20It's%20the%20same.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191056%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191056%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20open%20your%20old%20workbook%20and%20Save%20As%20it%20into%20new%20one%20(.xlsx)%20will%20it%20be%20the%20same%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191038%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191038%22%20slang%3D%22en-US%22%3EPerhaps%20the%20workbook%20is%20in%20shared%20mode%20(Review%20tab)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-191033%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-191033%22%20slang%3D%22en-US%22%3E%3CP%3ENo%2C%20it%20is%20not%20protected.%20Thanks.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190999%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20chart%2C%20option%20grayed%20out%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190999%22%20slang%3D%22en-US%22%3EIs%20the%20sheet%20protected%20by%20any%20chance%3F%3C%2FLINGO-BODY%3E
a g
Occasional Contributor

Using Excel Home and Business 2013 Version 15.0.5023.1000. Just updated it now. 

I had this same problem with an old spreadsheet, where suddenly I could no longer add new data to the chart. So created today a new sheet with new data, just 40 lines and 5 columns. I want to use data from 3 columns for chart as I had in old sheet. 

When I still couldn't insert chart, tried Help. The most relevant seeming thing had info only in video, only about Power View ( which apparently my version doesn't support) and the dumb video, if you paused it or tried to go back 10 seconds, the #@@%^ thing wouldn't restart unless I went back to beginning of video. #FAIL on on so many levels.

So I looked on this forum, and based on other threads, updated my version of Excel, checked that everything that's supposed to display is displayed (see attached), and still problem exists.

I'm not a power user but I've always been able to use my data to create charts no problem. Any suggestions on what might be the problem now? TIA. 

14 Replies
Is the sheet protected by any chance?

No, it is not protected. Thanks. 

Perhaps the workbook is in shared mode (Review tab)?

If you open your old workbook and Save As it into new one (.xlsx) will it be the same?

I tried that. It's the same. Thanks. 

Yes, it is in "shared" mode. I'm the only user I'm sharing with. I tried to remove myself and Excel wouldn't let me. Instead, it suggested closing the file. I did that, re-opened, and it's the same. How would I make it unshare?

When I looked in help, all I found was vague video info that co-authoring is better, though it didn't bother to say how specifically it's better or even in what versions of Excel co-authoring is in. I'm using Excel as part of Office 2013, desktop version, not 365 version.  I also didn't find what I was looking for, how to turn off sharing, since I'm the only one using this spreadsheet. 

Thanks. 

You should be able to unshare using the button on the review tab of the ribbon.

Please read my previous reply as to what happened when I tried to unshare it. I tried to unshare from the review tab (apologies that I didn't say specifically how I tried to unshare). What "should" happen isn't helpful if that's not what happens. 

Solution

The trick is to uncheck the box, see screen shots.

Share WB button.pngClick Share WorkbookUncheck Sharing.pngUncheck the box and OK

Thanks for taking the time to make the screen shots. I THOUGHT I'd already tried unchecking that box but at any rate it worked this time. Thanks. 

You're welcome. Glad this solved the issue.

@Jan Karel Pieterse wrote:
Is the sheet protected by any chance?

no  it is unprotected


@werkaroberto wrote:

@Jan Karel Pieterse wrote:
Is the sheet protected by any chance?

no  it is unprotected


 

IN Excel 2016, the share workbook button has been removed from the ribbon. You can add it to your Quick Access Toolbar temporarily, you may find the button if you select "All commands" from the dropdown.
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