what happened to "value from cells"?

%3CLINGO-SUB%20id%3D%22lingo-sub-1813679%22%20slang%3D%22en-US%22%3Ewhat%20happened%20to%20%22value%20from%20cells%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1813679%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20chart%3A%20Data%20labels%2C%20more%20options%2C%20format%20data%20labels%2C%20label%20options%2C%20label%20contains%20value%20from%20cells%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsually%20it%20the%20option%20is%20there%2C%20today%2C%20sometimes%2Fmostly%2C%20it%20is%20not.%20These%20are%20x-y%20scatter%20graphs.%20Once%20I%20thought%20it%20came%20back%20after%20pressing%20'f'%20which%20is%20the%20shortcut%20key%2C%20but%20if%20it%20worked%2C%20it%20only%20worked%20once.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1813679%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1814742%22%20slang%3D%22de-DE%22%3ESubject%3A%20what%20happened%20to%20%22value%20from%20cells%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814742%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F83338%22%20target%3D%22_blank%22%3E%40John%20Schindler%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%20(even%20if%20i%20am%20probably%20not%20the%20right%20one%20to%20suggest%20a%20solution%20to%20your%20problem)%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%2Fproblem%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1834397%22%20slang%3D%22en-US%22%3EBetreff%3A%20what%20happened%20to%20%22value%20from%20cells%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834397%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20actually%20pictures%20are%20the%20VERY%20best%20way%20to%20convey%20the%20situation%20but%20I%20haven't%20been%20able%20to%20get%20a%20picture%20of%20the%20way%20it%20used%20to%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20familiar%20with%20labeling%20data%20points%20in%20Excel%20charts%3F%20For%20years%2C%20there%20was%20a%20macro%20available%20to%20label%20points%20with%20cell%20contents%2C%20just%20like%20Quatro%20over%2020%20years%20ago.%20Then%20Microsoft%20built%20it%20into%20Excel%20and%20it%20has%20worked%20well%20for%20at%20least%20a%20couple%20of%20years.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1834457%22%20slang%3D%22de-DE%22%3ESubject%3A%20what%20happened%20to%20%22value%20from%20cells%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1834457%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F83338%22%20target%3D%22_blank%22%3E%40John%20Schindler%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22alt-edited%22%3EWith%20your%20permission%2C%20sir%2C%20I%20know%20that%20I%20know%20nothing.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EJust%20wanted%20to%20point%20out%20that%20you%20will%20get%20an%20answer%20faster%20with%20an%20inserted%20file%20(without%20sensitive%20data).%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EIn%20your%20case%20the%20Excel%20version%20and%20%2F%20or%20the%20operating%20system%20would%20be%20advantageous.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EBecause%20if%20you%20use%20Excel%20for%20Web%2C%20for%20example%2C%20some%20commands%20are%20not%20available.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EBut%2C%20it%20was%20a%20suggestion%2C%20if%20it%20doesn't%20help%2C%20please%20ignore%20it.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EThank%20you%20very%20much%20for%20your%20time%20and%20patience%20and%20I%20wish%20you%20every%20success%20in%20your%20project.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1835013%22%20slang%3D%22en-US%22%3EBetreff%3A%20what%20happened%20to%20%22value%20from%20cells%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1835013%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20glad%20my%20message%20is%20being%20seen.%20The%20next%20time%20I%20see%20Excel%20working%20the%20way%20I%20wish%20it%20would%2C%20I%20will%20save%20the%20file%20and%20upload%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

In a chart: Data labels, more options, format data labels, label options, label contains value from cells

 

Usually it the option is there, today, sometimes/mostly, it is not. These are x-y scatter graphs. Once I thought it came back after pressing 'f' which is the shortcut key, but if it worked, it only worked once.

8 Replies
Highlighted

@John Schindler 

With your permission, if I can recommend you (even if i am probably not the right one to suggest a solution to your problem), add a file (without sensitive data) to your project.

Explain your plans/problem in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the Excel version and operating system would also be an advantage.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@Nikolino 

 

Hi, actually pictures are the VERY best way to convey the situation but I haven't been able to get a picture of the way it used to work.

 

Are you familiar with labeling data points in Excel charts? For years, there was a macro available to label points with cell contents, just like Quatro over 20 years ago. Then Microsoft built it into Excel and it has worked well for at least a couple of years.

Highlighted

@John Schindler

 With your permission, sir, I know that I know nothing.
Just wanted to point out that you will get an answer faster with an inserted file (without sensitive data). In your case the Excel version and / or the operating system would be advantageous.
Because if you use Excel for Web, for example, some commands are not available.

However, it was a suggestion, if it doesn't help, please ignore it.

Thank you very much for your time and patience and I wish you every success in your project.

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@Nikolino 

 

I'm glad my message is being seen. The next time I see Excel working the way I wish it would, I will save the file and upload it.

 

John

Highlighted

@John Schindler 

In order not to be misunderstood, I am not from microsoft and am not paid by microsoft either.

Just like that, I don't pay anything to microsoft that I can use the forum here and the whole database of information that is available.

I am not paid for any help I offer. as well as not paying for any help I get or got in this forum.
Everything is on a voluntary basis (at least as far as my person is concerned),

help to be helped whenever I can or I need it.

I am sorry that you could not be helped in the way you wished.

But please keep in mind that you can only help a user insofar as he is willing to be helped.

However, I wish you every success and success in your project.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@John Schindler

image.png I this (enclosed picture) what we are discussing?

Highlighted

@Peter Bartholomew 

 

Yes, that option is what I used to see, but lately it is not available. I have tried with very simple data but I haven't seen the option lately. 

 

Perhaps there are some unspoken rules about when it will work.

Highlighted

@John Schindler I created the image using MS 365 Excel Insider.  AFAIK, the option shows when you seek to format existing data labels.