how do i plot last n data point

X

xxxxjoanne

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting NA() or #N/A data points 1
XY Charts - not plotting zero or #N/A Points 2
Employee Schedule not plotting properly - chart type / data series not correct 0
How to Plot This Data? 2
how do i plot last n data point 0
Excel 2007: Lines not displaying on Scatter Plots 1
Excel 2007: Lines not displaying on Scatter Plots 0
2709 point limit in Excel 2007 scatter plot 3

Top