Auto expanding X Axis for Chart

[Corey]

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

 

[trip_to_tokyo]

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.

 

[Jon Peltier]

PS. To Trip_to_tokio - noob question, but I am using mozila

thunderbird client, where do you hit yes?!

Ignore this, it's only relevant to users of the wonderful Microsoft web
interface to the newsgroups.

- Jon