Excel Charts - Option "Label contains value From cells" disappear

[Lasa1]

Hi,
I created a combo chart with clustered columns, lines and scatter with straight lines series and would like to add the labels to one of the series.However the Label Option "Values From Cells " is not showing .
However if I copy the sheet in a new book then the option appears... do you know what I need to do to have this option available in the original sheet?
I am using Microsoft 365.
Thanks

 

[RoryA]

What file format is the original workbook?

 

[Lasa1]

Original file is .xls and the new book is .xlsx

 

[RoryA]

That would explain it. That wasn't an option in earlier versions of Excel so I imagine it's not supported for storage in the old BIFF file format. Save the original file in a new format, and it should work.

 

[Lasa1]

Original file is .xls and the new book is .xlsx

Thanks, indeed that was the root casue. I saved the original file with .xlsx, close and reopen and nowthe lable option " value from cells" is available.Thanks