Bar chart by division, department, region date

[Stephanie]

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?

 

[FloMM2]

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