text bo x with value from cell on other sheet

[TFrisch]

I have a chart - at bottom of chart I have cells with
value form other sheet.

I am trying to ficx chart someone else made.

Can I pout a cell reference to another sheet in atext box
to get alignment

 

[Jon Peltier]

To get a textbox with a cell reference, select the chart, type an equals
sign, then select the cell with the mouse. If the cell is on another
sheet, you can navigate using the sheet tabs. If it's in another whole
workbook, navigate using the Windows menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

-----Original Message-----
To get a textbox with a cell reference, select the chart, type an equals
sign, then select the cell with the mouse. If the cell is on another
sheet, you can navigate using the sheet tabs. If it's in another whole
workbook, navigate using the Windows menu.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


.