Hello all,

I have 2 sheets, "Data Sheet" and "Chart Sheet". Data Sheet contains data
to create a bar chart in the Chart Sheet, including the data for bar chart
title. I have no problem creating the bar chart using the data in the Data
Sheet.

I am just wondering whether I can make the chart title dynamic, which means
whenever the value for chart title in the Data Sheet changes, the chart title
will change.

In addition, I want to insert an area on the bar chart for the Source
information. I also want the source information dynamic from the value from
the Data Sheet.

Can they be done?

Thanks.