K
Karen
I have a spreadsheet like below and I want to make separate (but the same
format) bar charts for each week
The top-left cell starts at cell A1 (The numbers below are hours)
This is a spreadsheet to log the amount of hours lost in the department and
the reason why productivity was delayed for that time.
Date Server Printer Temperature Network Data
Control
4/28/08 4
4/29/08 5
4/30/08
5/1/08 1
5/2/08 3
Totals 4 8 1
5/4/08
5/5/08
5/6/08 4 2
5/7/08
5/8/08 2 1 2
Totals 2 4 3 2
All I want in each chart are the column titles on the Y-axis (Server,
Printer, etc.), the date range at the top of the chart as a title, and the
total amount of hours lost somewhere on the chart. This spreadsheet spans
until 5/31/08, so I'll need many charts. Once I get the format correct on the
first chart, I want to use the same format for all the other charts so they
match. How do I set up this chart? I hope that I'm explaining this properly.
Thanks, Karen
format) bar charts for each week
The top-left cell starts at cell A1 (The numbers below are hours)
This is a spreadsheet to log the amount of hours lost in the department and
the reason why productivity was delayed for that time.
Date Server Printer Temperature Network Data
Control
4/28/08 4
4/29/08 5
4/30/08
5/1/08 1
5/2/08 3
Totals 4 8 1
5/4/08
5/5/08
5/6/08 4 2
5/7/08
5/8/08 2 1 2
Totals 2 4 3 2
All I want in each chart are the column titles on the Y-axis (Server,
Printer, etc.), the date range at the top of the chart as a title, and the
total amount of hours lost somewhere on the chart. This spreadsheet spans
until 5/31/08, so I'll need many charts. Once I get the format correct on the
first chart, I want to use the same format for all the other charts so they
match. How do I set up this chart? I hope that I'm explaining this properly.
Thanks, Karen