Only Include Last Four Entries in a Chart

  • Thread starter Thread starter asmithbcat
  • Start date Start date
A

asmithbcat

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?
 
asmithbcat said:
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?
Click to expand...

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/pub0009/LPMArticle.asp?ID=518.

Good luck,

V
 
Back
Top