J Walks - 'Chart From Combo Box' Snag

  • Thread starter Thread starter mathew
  • Start date Start date
M

mathew

Good evening all,

I have created charts using JW's 'Chart From Combo Box' in chapter 15 from his Excel 2000 functions CD.
This has worked great, being able to choose the required chart from the drop-down list, which I have adapted.

However, the 'chart titles' do not change to the appropriate value when I choose the suitable chart, but remain the same
throughout my choices, eg every chart title is called 'March', when in fact I am looking at a chart produced for February.

I have tried naming the title in Options/Chart Title, but still all charts remain with the same title.

This is really bugging me, and have spent hrs trying to figure this out, but to no avail.

Any help help here would be most appreciated, as my reports are for multiple access, and hence cannot post to the server until
fixed.

Cheers,
Mathew
 
Mathew -

I don't have that book, so I don't know exactly how he's set up the chart. Is the
title supposed to link to a cell? You can link the chart title, axis titles, and
data labels to cells by selecting the title or label, pressing the Equals key, then
clicking in the cell. You can't put any more complicated formula in the text link,
except that you can use a defined name rather than a cell reference:

=Sheet1!$A$1
=Sheet1!TheName

are both valid link formulas. If you want something more elaborate, construct the
formula you need in a worksheet cell, and link to this cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top