create chart linked to data in a series of worksheets

[hosehead]

using excel 2000, i need to create a chart showing sales in dollars for every
day in a given month, for example, november. in a workbook titled sales
reports, there is one sheet named for each day in the month. format on each
page is exactly the same. want to create a chart that will update chart when
data is added to worksheets each day.

 

[Jon Peltier]

If I understand your data layout, you need to compile the data into a single summary
sheet, then plot the compiled data. This page might help:

http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______