I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave the
right side of the chart empty.

Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

In article ,
says...
I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave the
right side of the chart empty.

On Tue, 23 Oct 2007, in microsoft.public.excel.charting,
Tushar Mehta said:

Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

says...
I have a worksheet which has a column of numbers which must be charted using
a line chart. Currently the column has 48 rows, but additional rows will be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave the
right side of the chart empty.

If you don't want the effort of creating and maintaining named ranges,
you can use the method I use every day for the charts I update daily at
work. I have line charts with Time-Scale x axes, that refer to ranges
that include the data columns and a single blank row underneath them.

(actually two blank rows in my case, because of the technique I'm using
to make step charts, but that's not important right now)

To add a new row to the chart each day, select the blank row and press
Ctrl-+ (i.e. Ctrl-Shift-=). If you have selected the entire worksheet
row, it will immediately insert a row below the data and above the blank
reference row. If you have not selected the entire row, but only a cell
or a few cells, it will prompt you for what you want to insert, and you
choose "Entire row".

You now have a new day's row in which to enter the new day's data, which
will appear in the chart without modification. The method takes a
fraction of the seconds it takes to enter the actual data each day, so
the time overhead is small, and the method can be taught to third
parties you delegate the data entry to, so you don't get people coming
back complaining that they've broken the chart.

If you use a line chart with simple category x axis, this method leaves
a single empty space on the right, which may be acceptable. If you
choose Time-scale x axis (via the menu, Chart.. Chart Options.. Axes.. )
then the blank space disappears.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

I have attempted to follow the guidance you have provided but with limited
success. Can you tell me what is meant by:


"The next and final step is to create a chart with the formula
=SERIES(,'Basic Range'!XValues,'Basic Range'!YValues,1)"




"Tushar Mehta" wrote in
message om...
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

In article ,
says...
I have a worksheet which has a column of numbers which must be charted
using
a line chart. Currently the column has 48 rows, but additional rows will
be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave
the
right side of the chart empty.

Finally figured it out.



"Patrick C. Simonds" wrote in message
...
I have attempted to follow the guidance you have provided but with limited
success. Can you tell me what is meant by:


"The next and final step is to create a chart with the formula
=SERIES(,'Basic Range'!XValues,'Basic Range'!YValues,1)"




"Tushar Mehta" wrote in
message om...
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

In article ,
says...
I have a worksheet which has a column of numbers which must be charted
using
a line chart. Currently the column has 48 rows, but additional rows will
be
added as more data becomes available.

Is there any way (maybe using VBA) go get the chart to update the data
series by add each new number added to the column?

I do not want to include a number of empty rows because that would eave
the
right side of the chart empty.