Forum Discussion
what happened to "value from cells"?
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.
16 Replies
I am having same issue - where has it gone!
UPDATE: I think this is to do with the provenance of the sheet, I may have resaved a .xls or .csv as an .xlsx and this precludes the 'values from cells' from appearing. Copying the data into a 'fresh' .xlsx and all is as it should be (for me at least!). JP
I will try that the next time it occurs, but if I recall correctly, this feature was coming and going while working on the same chart, in the same worksheet, over a period of time.
I am having same issue - where has it gone!
I still have a version (insider beta) where it still works fine, so it appears we are looking at a temporary glitch.
As Patrick2788 remarked, make sure that your workbook is not an Excel 97-2003 workbook (*.xls), but a standard Excel workbook (*.xlsx).
'Labels from Cells' is not available in an Excel 97-2003 workbook.
I this (enclosed picture) what we are discussing?
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.
unclejohnjohn I created the image using MS 365 Excel Insider. AFAIK, the option shows when you seek to format existing data labels.
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)
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.
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)
