text bo x with value from cell on other sheet

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

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/
_______

TFrisch wrote:

> 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

>-----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/
>_______
>
>TFrisch wrote:
>
>> 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
>
>.
>