automatic series readjustment when Inew row added

  • Thread starter Thread starter dale303
  • Start date Start date
D

dale303

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/charts/dynamic_chart_3.zip

Bullen http://www.bmsltd.ie/DLCount/DLCount.asp?file=FunChrt1.zip
XL-Logic http://www.xl-logic.com/xl_files/charts/dynamic_chart_1.zip
Bernard Liengme
http://www.stfx.ca/people/bliengme/ExcelTips/Dynamic.htm

Microsoft
http://support.microsoft.com/default.aspx?scid=kb;en-us;147803



Post back if you have any questions.

...Kelly

(e-mail address removed)
 
Back
Top