Automatically updating chart titles
Is there a way to have Excel automatically update the main Chart title
without having to double-click on the title and manually type in the new
title? I have a situation in which I have many different charts to generate
and it is easy to cut and paste the new data into the pre-existing graph to
replace the old data. However, I always have to manually fix the chart
title.
|