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

Hi Dean

Maybe you could have a lookup function to find the desired Title in a table
based on Type of Apple.

Then the title in the chart shall refer to the cell with the lookup
function.

Regards,
Per

"DA" <(E-Mail Removed)> skrev i meddelelsen
news:3723a134-7c0c-4a19-8e47-(E-Mail Removed)...
> 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

- Select the title
- Put the cursor in the input bar and type an =
- Select the cell you want linked to your title, or type say
='Sheet1!'$A$1
- press Enter

Regards,
Peter T

"DA" <(E-Mail Removed)> wrote in message
news:3723a134-7c0c-4a19-8e47-(E-Mail Removed)...
> 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