Hi there,

I have a worksheet full of data, which is filtered to provide a
meaningful list.

The data also populates a line graph on another worksheet.

When the data is filtered, I would like the axis of the line graph to
scale itself automatically to fit the data. (I have around 1200 rows of
data - which may be filtered down to around 20).

Each day the list of data will grow - so the scale of the axis will
need to change in line with this.

Could anyone offer any suggestions or pointers to guide me with this
problem?

Thank you all!

Rob :)


--
systemx
------------------------------------------------------------------------
systemx's Profile: http://www.excelforum.com/member.php...o&userid=29254
View this thread: http://www.excelforum.com/showthread...hreadid=525120