Cell text on chart

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi

Try this

- Select the chart
- in the formula bar write =
- with the mouse click on the cell
- press enter

You should see a label on the chart linked to the value of the cell.

Hope this helps
PGC
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
At a footnote to PGC's suggestion above, note that you can only reference a single cell in the formula. Any sort of calculation or manipulation would have to be done in the referenced cell (as opposed to the formula bar of the label/text box).
 

Watch MrExcel Video

Forum statistics

Threads
1,113,920
Messages
5,545,030
Members
410,647
Latest member
bernardazar
Top