I have a chart setup, currently with reference to 31 cells width.

The chart looks great if the user places a value in each of the 31 cells,
however if there are only say 20 values placed across the cell row, the
chart is displayed over to one side, with nil values displayed where no dat
values were entered.

Is there a way to have the chart automatically vary the width depending on
the amount of values entered across the refernced row of cells?

If there was only 20 values entered, then the chart would show 1-20 charted
and leave out the 21-31.


Corey....