Chart title made live?

  • Thread starter Thread starter DA
  • Start date Start date
D

DA

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
 
- 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

controlling chart location 1
Chart Title Reverts Back To Previous Value 3
Apparent Excel 2007 chart HasTitle race condition 5
programming 33 tabs with 1 chart on each, 9 series lines per chart 1
Dynamic Chart ranges 6
Formula in Chart Title via Macro 3
Pie Chart Tweaking? 1
Excel VBA Vs Chart Data Tables 2

Back
Top