I'd like to have a way, preferably without a macro, but if needed,
that's OK: so that a chart title can be "live" depednent on a vlaue
in a cell. For example,

Cost of Apple If Type of Apple = 3, where the 3 would be based on a
cell somehwere on the spreadhseet.

As far as i can tell, chart titles are text only, so there is no
trivial way to do this. So, I'm looking for the easiest way!

Thanks!
Dean