Auto expanding X Axis for Chart

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

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


.

What you need is dynamic range if I understand your problem right. Name
your data range as a dynamic range , and in the series of the chart put
the range name. Google how to do dynamic range, I don't remember on the
top of my head any website, but basically is done *RangeName *
*=Offset($A$1, 0,0, Counta(A:A), Counta($1:$1)*) ,then in chart data
series you put =sheet1!RangeName
Of course this needs to be customized for your particular range. If done
right, it'll chart only the cells with data, leaving the blank cells.
Hope that will give you the right direction.
Again try googling it - there is tons of websites explaining this
technique

Sam

PS. To Trip_to_tokio - noob question, but I am using mozila thunderbird
client, where do you hit yes?!

On 3/7/2010 9:12 PM, trip_to_tokyo wrote:
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....


.

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/8/2010 5:17 AM, Simeon wrote:
What you need is dynamic range if I understand your problem right. Name
your data range as a dynamic range , and in the series of the chart put
the range name. Google how to do dynamic range, I don't remember on the
top of my head any website, but basically is done *RangeName *
*=Offset($A$1, 0,0, Counta(A:A), Counta($1:$1)*) ,then in chart data
series you put =sheet1!RangeName
Of course this needs to be customized for your particular range. If done
right, it'll chart only the cells with data, leaving the blank cells.
Hope that will give you the right direction.
Again try googling it - there is tons of websites explaining this
technique

Sam


On 3/7/2010 9:12 PM, trip_to_tokyo wrote:
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....


.