software

Hi. My question may be difficult to explain, but here i go. I have a large
set of data which I analyze each week. I have created a vlookup function to
query weeknum amp; year which presents my data in a nice table format. I then
created a combo box with a quot;listquot; of all the colum names of data and quot;tied
inquot; the drop down line number into my vlookup function. I can now use my drop
down list to toggle through my data nicely. Here is my problem.

I have a chart which is driven off the data from the vlookup function. As i
toggle through my data with my combo box the chart updates. I'd like to be
able to have the charts do two things. 1-auto scale from something other than
zero on my Y access as i get large gaps below my data lines. 2-I'd like to be
able to have the chart names automatically update/change to whatever data i
am looking at through my combo box.
--
Regards,

Phil

Hi,

The chart titles can be linked to cells. depending on how you lookups
are working you may want to use a named range rather than a fixed cell
location.
www.andypope.info/tips/tip001.htm

If you haven't already have a look at Jon Peltier's interactive control
charts.
peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

phil clifford wrote:
gt; Hi. My question may be difficult to explain, but here i go. I have a large
gt; set of data which I analyze each week. I have created a vlookup function to
gt; query weeknum amp; year which presents my data in a nice table format. I then
gt; created a combo box with a quot;listquot; of all the colum names of data and quot;tied
gt; inquot; the drop down line number into my vlookup function. I can now use my drop
gt; down list to toggle through my data nicely. Here is my problem.
gt;
gt; I have a chart which is driven off the data from the vlookup function. As i
gt; toggle through my data with my combo box the chart updates. I'd like to be
gt; able to have the charts do two things. 1-auto scale from something other than
gt; zero on my Y access as i get large gaps below my data lines. 2-I'd like to be
gt; able to have the chart names automatically update/change to whatever data i
gt; am looking at through my combo box.

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info