I have a spreadsheet containing several charts and in the title of each chart
is a value. Sometimes I miss changing the value in a title from month to
month and it would be helpful to be able to reference a single cell for this
value.
I have a spreadsheet containing several charts and in the title of each chart
is a value. Sometimes I miss changing the value in a title from month to
month and it would be helpful to be able to reference a single cell for this
value.
Select the chart title, type an equal sign and click the cell, press enter
(you can also type equal sign and the sheet name and cell name like
=Sheet1!$G$1 and then press enter but it is easier if you can select the
cell with the mouse since excel will put in the name for you)
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"dveenhuis" <[email protected]> wrote in message
news:[email protected]...
>I have a spreadsheet containing several charts and in the title of each
>chart
> is a value. Sometimes I miss changing the value in a title from month to
> month and it would be helpful to be able to reference a single cell for
> this
> value.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks