create chart linked to data in a series of worksheets

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

Guest

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