Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel |