Thread: automatic series readjustment when Inew row added

I've got a sheet that records a date/time and a value next to the time.


I've got a xy scatter chart that plots the date/time the data was
entered (x values) against the value (y values). As I add new lines to
the series, how can I get the chart to automatically include the most
recently appended set of data?

It's a pita to readjust the series value ranges each time I append new
data.

Dale:

You need to set up a dynamic range for your X and Y values.

Here's a link to a how-to on my site.
http://processtrends.com/pg_dynamic_charts.htm

Here are several other dynamic chart links:


Jon Peltier http://peltiertech.com/Excel/Charts/Dynamics.html
XL-Logic
http://www.xl-logic.com/xl_files/cha...ic_chart_3.zip

Bullen http://www.bmsltd.ie/DLCount/DLCount...e=FunChrt1.zip
XL-Logic http://www.xl-logic.com/xl_files/cha...ic_chart_1.zip
Bernard Liengme
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Microsoft
http://support.microsoft.com/default...b;en-us;147803



Post back if you have any questions.

...Kelly

koday@processtrends.com




<dale303@gmail.com> wrote in message
news:1144748764.737042.62970@z34g2000cwc.googlegroups.com...
> I've got a sheet that records a date/time and a value next to the time.
>
>
> I've got a xy scatter chart that plots the date/time the data was
> entered (x values) against the value (y values). As I add new lines to
> the series, how can I get the chart to automatically include the most
> recently appended set of data?
>
> It's a pita to readjust the series value ranges each time I append new
> data.
>