I have a spreadsheet where the information begins at row 5 and carries on for
many more rows. The information is ranked with row 5 representing the latest
information, and the bottom row representing the oldest information. If I
have a chart that plots the "latest five values" (a5:a10), then I decide to
insert a new row 5, representing the very latest update, how do I keep Excel
from automatically updating the chart to plot a6:a11? I want it to stay
a5:a10, incorporating the latest row insert and dropping the oldest.