Use references in chart titles

rcavedo · May 1st, 2002, 10:52 AM

How do I refer to the contents of a cell when entering the Chart Titles i.e. Title, X-axis, y-axis? All of the data is in the spreadsheet. It seems to be a waste of time to re-type it for the chart wizard.

Thanks

Bob

rcavedo · May 6th, 2002, 03:34 PM

Question remains unanswered.
Does that mean it can't be done?

Mark W. · May 6th, 2002, 03:36 PM

See the Excel Help Index topic for "Link a chart title or text box to a worksheet cell".

rcavedo · May 6th, 2002, 03:46 PM

Works perfectly
I've used the cell reference technique between worksheets. It just never occured to me that I could use it with the chart wizard.

Thanks very much. It will save me much time and typing. Especially since the change will be dynamic.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 10:52 AM	#1
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	How do I refer to the contents of a cell when entering the Chart Titles i.e. Title, X-axis, y-axis? All of the data is in the spreadsheet. It seems to be a waste of time to re-type it for the chart wizard. Thanks Bob

May 6th, 2002, 03:34 PM	#2
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Question remains unanswered. Does that mean it can't be done?

May 6th, 2002, 03:36 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	See the Excel Help Index topic for "Link a chart title or text box to a worksheet cell".

May 6th, 2002, 03:46 PM	#4
rcavedo New Member Join Date: Apr 2002 Location: Robert F. Cavedo Posts: 26	Works perfectly I've used the cell reference technique between worksheets. It just never occured to me that I could use it with the chart wizard. Thanks very much. It will save me much time and typing. Especially since the change will be dynamic.