Forum Discussion
Nigel_Howarth
Feb 02, 2026Occasional Reader
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 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