Help needed, please - tables to piechart

  • Thread starter Thread starter PapaWishbone
  • Start date Start date
P

PapaWishbone

I have a table which summarises customer visits to my office each week. A new
table is added each Friday, appearing immediately below the previous week's, in
columns A - H.

The columns are: (time) 8.30-10,10 TO 12,2-2.30,2.30-4.00,4-5.15,Total (visits
in the time slot),%;
The rows are for waiting time, and are in increments of 5 minutes
(1-5,6-10,11-15, etc) up to 60 minutes. The final row is the column totals.

What I need to be able to do is create a chart (or two, if necessary) which
shows an at-a-glance summary of busiest times of day and length of query, using
data collated from ALL weekly tables. It would need to automatically update
each time a new week's information is added.

Any advice on how to do this would be great, and so thanks in advance.

PapaWeesh
 
Papaweesh

I would have two charts, one for the morning up to 12 noon
and another with 3 sets for the afternoon.

Type of chart either Bar or Bar and Line (in the custom
charts)

Sumarizing data: You can total all the values assuming
that the tables are identical. Insert a new sheet and copy
the heading. In the first data cell type this formula

=SUM(Sheet1:Sheet3!B4)

If you have more than 3 sheets just type =sum( and select
the first cell, hold shift and click on the last sheet tab.
Press enter to complete the formula.

Copy this formula down and across to complete the table.

Inserting a new weeks sheet. New sheets are inserted
before the active sheet so the new sheet will be included
in the data range

Regards
Peter
 
Back
Top