concatenate in chart titles

C

Charlie C

Hi - how can I get a title in a chart so it can take the contents of a cell. For example, I want the chart title to say "Population for [state name]" So eerytime the name of the state changes in a cell the chart title will change also

Charlie
 
Top