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
 

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
Data points in chart incorrect 0
XY Charts - not plotting zero or #N/A Points 2
Average bar charts with individual data points 2
Employee Schedule not plotting properly - chart type / data series not correct 0
Organizing Plot Points 0
Plotting x-y data to same physical dimension on plot 2
2nd axis plotting incorrectly - is there a chart size limit? 2

Top