I have a similar graph showing rolling 12 months. Insert a row in between
the last row and the 2nd to last row. Copy the last row into the NEW second
to last row, then put your new data into the last row. Hide the row(s) you
no longer want on the graph.

"Live Long & Prosper" wrote:

I'm embarrassed to ask, but I can't figure it out :) I have 5 columns that
are charted and on a daily/weekly basis I have new data to enter with each
new day. I want the chart to reflect the data for the last 60 days.

My problem is when I insert new cells and push the data down, the refernces
in the chart move as well, so its not showing the last 60 days. I'd like
the chart to reflect sliding data (I think thats the term).

HELP :)
.