L
LiAD
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?
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?