![]() |
Bar Chart
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 |
All times are GMT +1. The time now is 09:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com