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