How do I enter cell data in a footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlshep - 30 Sep 2006 15:37 GMT

I'd like to enter a sum total from a cell into a footer on a chart to show
how many reponses there were to a feedback questionaire, that is assuming
this is possible of course.

Reply to this Message

Andy Pope - 30 Sep 2006 16:03 GMT

Hi,

You can add a linked textbox to the chart.
With the chart active use the formula bar to type in the cells address,
including sheet name, so for example the sum total is in cell A12 on
sheet1 the formula refrence would be,

=Sheet1!A12

when you press Enter the textbox will be added to the chart. Position
and format as required.

Cheers
Andy

> I'd like to enter a sum total from a cell into a footer on a chart to show
> how many reponses there were to a feedback questionaire, that is assuming
> this is possible of course.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message