If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bar chart by division, department, region date
Hi. I'm very new to charting and hope you can steer me in the correct
direction. I want to look at trends over a rolling 12 month, for a business unit that has many departments that each have regions. Dept 1: reg A (2 issues this month), reg B (3 issues this month), reg C (1 issue this month) Dept 2: reg A (3 issues this month), reg B (0 issues this month) Can this all be plotted in one bar graph? What would my spreadsheet need to look like and would a regular bar graph work? |
#2
|
|||
|
|||
Bar chart by division, department, region date
Stephanie,
Thisis what I came up with: Cell A1 type "Dept 1", Cell C1 type "Dept 2" Cell A2 type "reg A", Cell A3 type "reg B", Cell A4 type "reg C" Cell B2 type "2", Cell B3 type "3", Cell B4 type "1" Cell C2 type "3", Cell C3 type "0" All this from your example. Then select cells A1 thru C4 with mouse. Select Chart wizard icon. In Chart type: Select Bar In Chart Sub-type, you want the first chart. Press and Hold button will preview your chart. Select "Next" Select the "Series" tab. Select the "blank series" and in the Name: box type "="Dept 1"" or Select the cell A1 on spreadsheet. Select "Next" You can fill in chart options if you like. Select "Next" Select "As object in:" or "As new sheet" Whichever works best for you. hth Dennis "Stephanie" wrote: Hi. I'm very new to charting and hope you can steer me in the correct direction. I want to look at trends over a rolling 12 month, for a business unit that has many departments that each have regions. Dept 1: reg A (2 issues this month), reg B (3 issues this month), reg C (1 issue this month) Dept 2: reg A (3 issues this month), reg B (0 issues this month) Can this all be plotted in one bar graph? What would my spreadsheet need to look like and would a regular bar graph work? |
Thread Tools | |
Display Modes | |
|
|