Auto set data ranges
 

Evening,

Supposing I have a standard table of 2 columns and 20 rows, col A has names
col B has numbers, which I then plot on some sort of graph. As this comes
from an auto input worksheet there may be some cells containing zeros. The
table will be ordered so the zeros are at the end.

Rather than the user having to update the chart range each time is it
possible to set some sort of function on the chart range to tell it only to
pick up and plot the non zero cells? This also avoids having big charts with
the last few categories empty as the input cells were empty.

Does anyone know if auto data ranges are possible for charts?

Auto set data ranges
 

Pivot charts if required please get back
--
Thanks
Suleman Peerzade


"LiAD" wrote:

Evening,

Supposing I have a standard table of 2 columns and 20 rows, col A has names
col B has numbers, which I then plot on some sort of graph. As this comes
from an auto input worksheet there may be some cells containing zeros. The
table will be ordered so the zeros are at the end.

Rather than the user having to update the chart range each time is it
possible to set some sort of function on the chart range to tell it only to
pick up and plot the non zero cells? This also avoids having big charts with
the last few categories empty as the input cells were empty.

Does anyone know if auto data ranges are possible for charts?

Auto set data ranges
 

HI,

I would rather avoid going towards pivoit charts if possible. Do you know
of any other solution?

Thanks for your help

"Suleman Peerzade" wrote:

Pivot charts if required please get back
--
Thanks
Suleman Peerzade


"LiAD" wrote:

Evening,

Supposing I have a standard table of 2 columns and 20 rows, col A has names
col B has numbers, which I then plot on some sort of graph. As this comes
from an auto input worksheet there may be some cells containing zeros. The
table will be ordered so the zeros are at the end.

Rather than the user having to update the chart range each time is it
possible to set some sort of function on the chart range to tell it only to
pick up and plot the non zero cells? This also avoids having big charts with
the last few categories empty as the input cells were empty.

Does anyone know if auto data ranges are possible for charts?