Forum Discussion

Nigel_Howarth's avatar
Nigel_Howarth
Copper Contributor
Feb 02, 2026
Solved

Format Data Labels - Value from Cells

I have a spreadsheet (below) that I wish to show in two different ways: The actual numbers in each of the cells Domestic, Overseas, EU, and Non-EU as shown. The percentage values as shown in t...
Charting
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Feb 02, 2026

    Hi Nigel

    No idea where this comes from but found it strange:

    1. Removed Data Label on all series
    2. Added them again
    3. Formatted each Data Label > Values From Cells > Selected the full range (rows 5-22):

    I case this would matter… running 365 v2601- b19628.20150 / Windows
    (bordered cell B18 where 2021 is stored as Text - something you'll probably want to fix…)

Resources