I have a worksheet with a name in cell A1. There are 18 charts on the
worksheet.

I'd like to have the chart headings read the name in cell A1 and
display that as part of the chart heading on each of the 18 charts.

Then, I'd also like to create multiple copies of this worksheet, change
the name in cell A1 on each of the copies, and have the new names from
cells A1 of each worksheet appear on the 18 charts on that page.

I have a less than satisfactory workaround when there's only 1 page.
It involves creating a picture of cell A1 and overlaying it where the
chart headings are. But, when new worksheets are created using this as
a master, the pictures all still refer to the original sheet, so this
isn't a feasible method with many pages of charts.

Is it possible to, and how can I, have chart headings pick up the
contents of a cell?


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=497027

Here's how to do it with once chart:
Make chart, give it any title (that is the correct word)
Click on title, type = in Formula box and click on cell A1
Done
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"rsenn" wrote in
message ...

I have a worksheet with a name in cell A1. There are 18 charts on the
worksheet.

I'd like to have the chart headings read the name in cell A1 and
display that as part of the chart heading on each of the 18 charts.

Then, I'd also like to create multiple copies of this worksheet, change
the name in cell A1 on each of the copies, and have the new names from
cells A1 of each worksheet appear on the 18 charts on that page.

I have a less than satisfactory workaround when there's only 1 page.
It involves creating a picture of cell A1 and overlaying it where the
chart headings are. But, when new worksheets are created using this as
a master, the pictures all still refer to the original sheet, so this
isn't a feasible method with many pages of charts.

Is it possible to, and how can I, have chart headings pick up the
contents of a cell?


--
rsenn
------------------------------------------------------------------------
rsenn's Profile:
http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=497027

Bernard,

Thanks, but it seems not to work for me.

Could you e-mail me a sample spreadsheet where it works?

Randall dot Senn @ excite dot com




--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=497027