Only Include Last Four Entries in a Chart
 

I have a very simple chart that I am putting together on a weekly basis. I
want the chart to show only the last four entries, but I do not want to
update the source data every time I need a new chart. However, I want a
historical record of the data, so I don't want to delete any entries.

Is there a way to set up the source data so that it only pulls the last four
entries in a specific range?

Only Include Last Four Entries in a Chart
 

"asmithbcat" wrote in message
...
I have a very simple chart that I am putting together on a weekly basis. I
want the chart to show only the last four entries, but I do not want to
update the source data every time I need a new chart. However, I want a
historical record of the data, so I don't want to delete any entries.

Is there a way to set up the source data so that it only pulls the last
four
entries in a specific range?

Dynamic Charting is what you need! If you put the words into Google you'll
find lots of helpful articles on the subject including
http://pubs.logicalexpressions.com/p...cle.asp?ID=518.

Good luck,

V