charts and cells

[rsenn]

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?

[Bernard Liengme]

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" <rsenn.20vcdn_1135972502.2847@excelforum-nospam.com> wrote in
message news:rsenn.20vcdn_1135972502.2847@excelforum-nospam.com...
>
> 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
>

[rsenn]

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