Auto Y-Axis Scale

[systemx]

Hi there,

I have a worksheet full of data, which is filtered to provide
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 t
scale itself automatically to fit the data. (I have around 1200 rows o
data - which may be filtered down to around 20).

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

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

Thank you all!

Rob :

 

[systemx]

Sorry,

Not sure if I was really clear on what I want to do, so thought
should add to my post.

I would like to set the 'Y' axis data range as an entire column (e
A:A) - and for excel to recognise that if a cell is blank, it shoul
not be part of the chart.

That way, no matter what the filter, the axis will always be set to th
data being viewed.

Thanks again

Ro