All right I have been working on this for awhile and I cannot seem to
get it perfect. I have a number of charts that take daily security
information and chart it as a time series. I am trying to automate
this by using named ranges. When I do this the chart's x axis extends
much further than the data which is charted. Is there a way to use a
countif or sumproduct funtion in the offset formula to only chart the
used data? Any workaround would be appreciated.

Thanks,
Cory


--
cooter24
------------------------------------------------------------------------
cooter24's Profile: http://www.excelforum.com/member.php...o&userid=29619
View this thread: http://www.excelforum.com/showthread...hreadid=505416