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.

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/ChartsH...iffSheets.html

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

hosehead wrote:

> 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.