how do i plot last n data point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the excel 2000 formulas book on charts Iam trying to create a
chart that plots the most recent 12 data inputs. but when I try to follow the
book on replacing the range referances it keeps putting errors up saying the
fomula does not work.
The formula is =series(,sheet1!dates,sheet1!sales,1).
can someone help
 
Back
Top