| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I enter cell data in a footer
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How do I enter cell data in a footer
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 Carlshep wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record changing cell data into a column or range | Excel Worksheet Functions | |||
| Lock the cell once enter the data | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| ENTER A FORMULA IN A CELL TO UTILIZE THE IMPORT DATA FUNCTIONS? | Excel Worksheet Functions | |||
Linear Mode
