EXCEL 2007

Hi Corey take a look at:-

http://www.pierrefondes.com/

- item number 72.

This is a similar problem.

You don't say what's on the X axis so I am nut sure whether or not this
example will help.

In the example I have given the X axis was set to:-

Text axis

- and this removed the Sundays from the data shown on the graph.

If my comments have helped please hit Yes.

Thanks.



"Corey" wrote:

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....


.