Forum Discussion

Nigel_Howarth's avatar
Nigel_Howarth
Occasional Reader
Feb 02, 2026

Format Data Labels - Value from Cells

I have a spreadsheet (below) that I wish to show in two different ways:

  1. The actual numbers in each of the cells Domestic, Overseas, EU, and Non-EU as shown.

  2. The percentage values as shown in the %age domestic, %age overseas, etc..

Using the Format Data Labels and selecting Value From Cells, I can do this for any 2 of the 4 columns.

However, when I try to select Value From Cells from the third and/or fourth column, nothing appears in the bar chart - it's completely blank (apart from the background colour.)

I have uploaded the failing sheet, which can be downloaded by https://c3a-cyprus.org/test-work.xlsx.

I'd appreciate any thoughts

TIA

Nigel

No RepliesBe the first to reply

Resources