D Doug Akers Feb 11, 2004 #1 I would like to have the title of a chart change based on a specific cell on the spreadsheet. Any suggestions?
I would like to have the title of a chart change based on a specific cell on the spreadsheet. Any suggestions?
F Frank Kabel Feb 11, 2004 #2 Doug said: I would like to have the title of a chart change based on a specific cell on the spreadsheet. Any suggestions? Click to expand... Hi Doug - click in the title field of your chart - enter =cell_reference also have a look at: http://www.tushar-mehta.com/excel/newsgroups/dynamic_chart_title/index. html Frank
Doug said: I would like to have the title of a chart change based on a specific cell on the spreadsheet. Any suggestions? Click to expand... Hi Doug - click in the title field of your chart - enter =cell_reference also have a look at: http://www.tushar-mehta.com/excel/newsgroups/dynamic_chart_title/index. html Frank
J Jon Peltier Feb 11, 2004 #3 Even easier than typing the cell reference: Select the chart title Type = Select the cell with the mouse Also works with axis titles and data labels. - Jon
Even easier than typing the cell reference: Select the chart title Type = Select the cell with the mouse Also works with axis titles and data labels. - Jon
