Expanding a chart

[Guest]

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.

 

[Tushar Mehta]

Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[Del Cotter]

Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

(e-mail address removed) says...

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.

 

[Patrick C. Simonds]

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)"

 

[Patrick C. Simonds]

Finally figured it out.

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)"