how do i plot last n data point

  • Thread starter xxxxjoannexxxx(8)i hope u ave the time o
  • Start date
X

xxxxjoannexxxx(8)i hope u ave the time o

I am using the john walkenbach book excel2000 formulas.
When i try the example plotting the last n data points. when i try to alter
the ranges in the graph as per the example i keep getting errors on the
formula the formula is =series(,sheet1!date,sheet1!sales,1)
what am i doing wrong
 
Top